是否可以将实体框架与 DB2 iSeries AS/400 一起使用
我是 Microsoft 实体框架的新手，想知道是否可以将此框架与 DB2 iSeries AS/400 一起使用？使用这种“遗留系统”时是否存在任何问题？和 EF 框架？
Im new to Microsoft entity framework and wonders if it's possible to use this framework with a DB2 iSeries AS/400? Are there any problems at all when working with this kind of "legacy systems"? and the EF framework?
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（2）
您可以使用实体框架通过以下三种方式之一连接到 ISeries DB2 数据库：
1. 如果您购买 IBM 的 DB2 Connect 产品的许可证。许可证价格约为 12,000 美元，这太离谱了。此外，还没有足够好的文档来说明 DB2 Connect 产品的实际工作方式、安装方式或其可能的好处。我联系了他们的一位经销商进行测试安装，但这不是一个直观的过程，因此我们从未购买该产品。同样，似乎没有任何演示。我不明白 IBM 如何拥有最好的服务器之一，但却不竭尽全力向 Microsoft 开发人员利用他们的产品。
也就是说，如果您研究这个主题，您会发现很多信息表明您可以通过其 ADO.Net 数据服务器提供程序来使用实体框架。我沿着这条路走，但我会警告您，他们的数据服务器提供程序仅在安装了 DB2 connect 时才起作用。这很令人困惑，因为 IBM 宣传此功能，但通常不显示这两个产品之间的直接关联，因此您经常会认为它无需 db2 connect 也能工作，但目前情况并非如此。
2. 购买专为实体框架设计的第三方数据提供商。 Progress 软件的 Data Direct 非常易于使用。我不喜欢他们的服务器许可的工作方式，因为他们的服务器许可是针对您的应用程序服务器的每个核心处理器。这是有缺陷的，因为这假设您只有一个应用程序服务器，而实际上，人们通常需要拥有不同的应用程序服务器来实现负载平衡。我希望他们只针对一台 ISeries 服务器进行许可。但是，如果您决定这样做，则可以为每个单独用户购买许可证。
3.编写您自己的数据提供程序。这是可能的，但有明显的缺点。
You can use Entity Framework to connect to an ISeries DB2 database one of three ways:
1. If you purchase the license to IBM's DB2 Connect product. The license is around $12,000 which is outrageous. Also, there is not enough good documentation for how the DB2 Connect product actually works, how it installs, or its possible benefits. I've contacted one of their resellers to get a test install and it was not an intuitive process so we never purchased the product. Likewise, there doesn't appear to be any demos. I don't understand how IBM can have one of the best servers available but don't bend over backwards to leverage their product to Microsoft developers.
That said, if you research this topic you will find much information saying that you can use Entity Framework using their ADO.Net data server provider. I went down this path but I will warn you that their data server provider only works when DB2 connect is installed. This is confusing because IBM advertises this ability but doesn't often show the direct correlation between the two products so you're often left thinking that it will work without db2 connect which it will not at this time.
2. Purchase a third party data provider designed for Entity Framework. Progress software's Data Direct is super easy to use. I don't like how their server licensing works though because their server license is per core processor for your app server. This is flawed because this assumes you only have one app server when in reality, people regularly need to have different app servers for load balancing. I would prefer they just license per one ISeries server. However, you can purchase the licenses for each individual user if you decide to do that.
3. Write your own data provider. This is possible but there are obvious drawbacks.
看起来有点像 - 请参见此处：
http://publib.boulder.ibm.com/infocenter/db2luw/v9r5/topic/com.ibm.swg .im.dbclient.adonet.doc/doc/c0054118.html?resultof=%22%65%6e%74%69%74%79%22%20%22%65%6e%74%69%74%69% 22%20%22%66%72%61%6d%65%77%6f%72%6b%22%20
但老实说，我不是 100% 确定 - 特别是如果它支持 EF 4.0 （然而）。
或者查看 IBM DB2Connect 站点并从那里进行搜索...
It sort of looks like it is - see here:
http://publib.boulder.ibm.com/infocenter/db2luw/v9r5/topic/com.ibm.swg.im.dbclient.adonet.doc/doc/c0054118.html?resultof=%22%65%6e%74%69%74%79%22%20%22%65%6e%74%69%74%69%22%20%22%66%72%61%6d%65%77%6f%72%6b%22%20
but quite honestly, I'm not 100% sure - especially not if it supports EF 4.0 (yet).
Or check out the IBM DB2Connect site and search from there...