All geek questions in one place

How to get the IBM DB2 provider to work with Entity Framework 4.0

Can someone tell me how to get the DB2 provider to appear in the Change Data Source dialog box?

Steps:

  • Right-click on the edmx design surface.
  • Select "Update Model From Database"
  • In the update wizard, click "New Connection"
  • Next to the Data Source text box, click Edit ...

In the "Change data source" window, I see only the following data sources in the list:

Microsoft SQL Server Microsoft SQL Server Compact 3.5 Microsoft SQL Server Database File <other>

When I select "other", I see only two entries in the Data Provider drop-down list:

 .Net Framework Data Provider for Microsoft SQL Server Compact 3.5 .Net Framework Data Provider for SQL Server

How do I find DB2 providers (s) so that I can use them to model DB2 tables?

I can successfully connect to DB2 using VS2010 Server Explorer. The connection string for this is:

 "Provider=IBMDADB2.DB2COPY1;Data Source=DB2THLOC;Persist Security Info=True;User ID=****;Location=****" (stars for security)

The provider is listed as:

 .NET Framework Data Provider for OLE DB Type: DB2 Version: 08.01.0005

Thanks a lot in promoting

+4
source share
2 answers

What you are describing is included in the IBM Visual Studio Add-in Package. There is currently no such package for vs2010.

+2
source

There are already relevant providers there. Drivers v9.7 FP4 or later work with VS 2010 EF 4.

0
source

Source: https://habr.com/ru/post/1308155/

More articles:


All Articles