Global Data Management Forum

I am trying to create a sample application described in this blog: https://community.ibm.com/community/user/hybriddatamanagement/blogs/michelle-betbadal1/2020/04/29/code-based-configuration-of-ef6-provider-for-ibm-d

I had version 10 installed before, using this installer: v10.5fp2_ntx64_dsdriver_ALL_LANG.exe

When I installed v11.5.7_ntx64_dsdriver_ALL_LANG.exe, it removed invariant="IBM.Data.DB2" provider from my machine.config, and I couldn't even install VS Add-In using v11.5.7_nt32_vsai.exe. I need VS Add-In to be able to connect to DB2 database, and create EDMX file and generate entities.

I was only be able to make the sample working after:

1. install v11.5.7_ntx64_dsdriver_ALL_LANG.exe

2. install v10.5fp2_ntx64_dsdriver_ALL_LANG.exe
3. install v11.5.7_nt32_vsai.exe

The packages were installed successfully: 

  <package id="EntityFramework" version="6.4.0" targetFramework="net48" />
  <package id="EntityFramework.IBM.DB2" version="6.4.1" targetFramework="net48" />

This is my machine.config:

This is machine config:

  <system.data>
    <DbProviderFactories>
      <add name="IBM DB2 .NET Data Provider 10.5.2" invariant="IBM.Data.DB2.10.5.2" description="IBM DB2 Data Provider 10.5.2 for .NET Framework 4.0" type="IBM.Data.DB2.DB2Factory, IBM.Data.DB2.10.5.2, Version=10.5.2.4, Culture=neutral, PublicKeyToken=7c307b91aa13d208" />
      <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 DB2 .NET Data Provider 11.5.7000" invariant="IBM.Data.DB2.11.5.7000" description="IBM DB2 Data Provider 11.5.7000 for .NET Framework 4.0" type="IBM.Data.DB2.DB2Factory, IBM.Data.DB2.11.5.7000, Version=11.5.7000.4, Culture=neutral, PublicKeyToken=7c307b91aa13d208" />
    </DbProviderFactories>
  </system.data>

If I just install version 11, my machine config will be like this:

This is machine config:

  <system.data>
    <DbProviderFactories>
      <add name="IBM DB2 .NET Data Provider 11.5.7000" invariant="IBM.Data.DB2.11.5.7000" description="IBM DB2 Data Provider 11.5.7000 for .NET Framework 4.0" type="IBM.Data.DB2.DB2Factory, IBM.Data.DB2.11.5.7000, Version=11.5.7000.4, Culture=neutral, PublicKeyToken=7c307b91aa13d208" />
    </DbProviderFactories>
  </system.data>

Notice missing non-versioned provider invariant="IBM.Data.DB2". I guess it prevented installing VSAI and configuring connection to DB2.