是否可以将实体框架与 DB2 iSeries AS/400 一起使用 [英] Is it possible to use Entity Framework with a 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?

推荐答案

您可以使用 Entity Framework 连接到 ISeries DB2 数据库的三种方式之一:

You can use Entity Framework to connect to an ISeries DB2 database one of three ways:

1.如果您购买了 IBM DB2 Connect 产品的许可.许可证大约是 12,000 美元，这太离谱了.此外，对于 DB2 Connect 产品的实际工作方式、安装方式或可能的好处，也没有足够好的文档.我联系了他们的一位经销商以进行测试安装，这不是一个直观的过程，因此我们从未购买过该产品.同样，似乎没有任何演示.我不明白 IBM 怎么能拥有最好的服务器之一，但又不向后弯腰向 Microsoft 开发人员利用他们的产品.

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.

也就是说，如果您研究这个主题，您会发现很多信息表明您可以使用他们的 ADO.Net 数据服务器提供程序来使用 Entity Framework.我沿着这条路走，但我会警告您，他们的数据服务器提供程序仅在安装 DB2 connect 时才有效.这很令人困惑，因为 IBM 宣传了这种能力，但并不经常显示这两种产品之间的直接关联，因此您经常认为它可以在没有 db2 connect 的情况下工作，而目前它不会.

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. 购买专为实体框架设计的第三方数据提供商.Progress 软件的 Data Direct 超级好用.我不喜欢他们的服务器许可的工作方式，因为他们的服务器许可是针对您的应用服务器的每个核心处理器.这是有缺陷的，因为这假设您只有一个应用程序服务器，而实际上，人们经常需要不同的应用程序服务器来进行负载平衡.我希望他们只为每个 ISeries 服务器提供许可.但是，如果您决定这样做，您可以为每个单独的用户购买许可证.

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. 编写您自己的数据提供程序.这是可能的，但也有明显的缺点.

3. Write your own data provider. This is possible but there are obvious drawbacks.

这篇关于是否可以将实体框架与 DB2 iSeries AS/400 一起使用的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！