如何使IBM DB2提供程序与Entity Framework 4.0一起工作 [英] How to get the IBM DB2 provider to work with Entity Framework 4.0
问题描述
步骤:
- 右键单击edmx设计面。
- 选择从数据库更新模型
- 在更新向导中,单击新建连接
- 在数据源文本框旁边,单击更改...
在更改数据源窗口中,我只看到列表中的以下数据源:
Microsoft SQL Server
Microsoft SQL Server Compact 3.5
Microsoft SQL Server数据库文件
< other>
当我选择其他时,我只在Data Provider下拉列表中看到两个条目:
用于Microsoft SQL Server Compact 3.5的.NET Framework数据提供程序
SQL Server的数据提供程序
如何让DB2提供程序显示在这里,以便我可以使用它们来建模DB2表? / p>
我可以使用VS2010 Server Explorer成功连接到DB2。连接字符串为:
Provider = IBMDADB2.DB2COPY1;数据源= DB2THLOC; Persist Security Info = True;用户ID = ****;位置= ****(为安全起见)
被列为:
OLE DB的.NET Framework数据提供者
类型:DB2
版本:08.01 $ 5000
非常感谢提前
您正在描述的内容是由IBM的Visual Studio加载项包启用的。目前,vs2010没有这样的包。
Can someone please tell me how to get the DB2 provider to show up in the "Change Data Source" dialog window?
Steps:
- Right-click on the edmx design surface.
- Select "Update Model from Database"
- On the Update Wizard, click "New Connection"
- 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
What you're describing is enabled by the Visual Studio Add-In package from IBM. Currently, there is no such package for vs2010.
这篇关于如何使IBM DB2提供程序与Entity Framework 4.0一起工作的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!