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

visual-studio db2 entity-framework-4 provider

10,735

What you're describing is enabled by the Visual Studio Add-In package from IBM. Currently, there is no such package for vs2010.

10,735

Author by

camainc

My day job: I am a senior-level .Net Developer, a mentor, and a part-time programming instructor. My passion: I'm the Co-Founder and Director of Myanmar Hope Christian Mission, Inc., an international non-profit dedicated to helping the tribal people of northwest Myanmar rise out of poverty. My hobbies: Watercolor painting and reading.

Updated on June 04, 2022

Comments

camainc almost 2 years
Can someone please tell me how to get the DB2 provider to show up in the "Change Data Source" dialog window?

Steps:
1. Right-click on the edmx design surface.
2. Select "Update Model from Database"
3. On the Update Wizard, click "New Connection"
4. Next to the "Data source" textbox, click "Change..."
In the Change Data Source window, I am only seeing 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 only see two entries in the Data Provider dropdown:
```
.Net Framework Data Provider for Microsoft SQL Server Compact 3.5
.Net Framework Data Provider for SQL Server
```
How do I get the DB2 provider(s) to show up here so that I can use them to model my DB2 tables?

I am able to successfully connect to DB2 using the VS2010 Server Explorer. The Connection string for that 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
```
Many Thanks In Advance