IBM DB2 Entityframework issue

db2 entity-framework-6 visual-studio-2015

Popular Answer

With a comparable configuration (VS2015, EntityFramework 6.2, EntityFramework.IBM.DB2 6.1), I was experiencing the exact same issue, but I was able to resolve it.

After switching my target framework from 4.5.1 to 4.6.1 after seeing a reference to.net 4.6.1, the problem was resolved!

The IBM application versions and configuration that I used were shown below.

Machine.config

<add name="Microsoft SQL Server Compact Data Provider 4.0" invariant="System.Data.SqlServerCe.4.0" description=".NET Framework Data Provider for Microsoft SQL Server Compact" type="System.Data.SqlServerCe.SqlCeProviderFactory, System.Data.SqlServerCe, Version=4.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91" />
  <add name="IBM DB2 .NET Data Provider" invariant="IBM.Data.DB2" description="IBM DB2 Data Provider for .NET Framework 4.0" type="IBM.Data.DB2.DB2Factory, IBM.Data.DB2, Version=9.7.4.4, Culture=neutral, PublicKeyToken=7c307b91aa13d208" />
  <add name="IBM Informix .NET Data Provider" invariant="IBM.Data.Informix" description="IBM Informix Data Provider for .NET Framework 4.0" type="IBM.Data.Informix.IfxFactory, IBM.Data.Informix, Version=9.7.4.4, Culture=neutral, PublicKeyToken=7c307b91aa13d208" />
  <add name="IBM DB2 .NET Data Provider 10.5.6" invariant="IBM.Data.DB2.10.5.6" description="IBM DB2 Data Provider 10.5.6 for .NET Framework 4.0" type="IBM.Data.DB2.DB2Factory, IBM.Data.DB2.10.5.6, Version=10.5.6.4, Culture=neutral, PublicKeyToken=7c307b91aa13d208" />
  <add name="IBM Informix .NET Data Provider 10.5.6" invariant="IBM.Data.Informix.10.5.6" description="IBM Informix Data Provider 10.5.6 for .NET Framework 4.0" type="IBM.Data.Informix.IfxFactory, IBM.Data.Informix.10.5.6, Version=10.5.6.4, Culture=neutral, PublicKeyToken=7c307b91aa13d208" />

App.config

  <entityFramework>
<defaultConnectionFactory type="System.Data.Entity.Infrastructure.SqlConnectionFactory, EntityFramework"/>
<providers>
  <provider invariantName="System.Data.SqlClient" type="System.Data.Entity.SqlServer.SqlProviderServices, EntityFramework.SqlServer"/>
  <provider invariantName="IBM.Data.DB2" type="IBM.Data.DB2.EntityFramework.DB2ProviderServices, IBM.Data.DB2.EntityFramework, Version=10.5.5.6, Culture=neutral, PublicKeyToken=7c307b91aa13d208"/>
</providers>

placed IBM Applications in placeInstalled IBM Versions

1
1/4/2019 4:40:51 PM


Related Questions





Related

Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow
Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow