使用DB2 iSeries AS / 400可以使用Entity Framework [英] Is it possible to use Entity Framework with a DB2 iSeries AS/400
问题描述
您可以使用Entity Framework连接到ISeries DB2数据库三种方式之一：
1。如果您将许可证购买到IBM的DB2 Connect产品。许可证约为12,000美元，这是荒谬的。此外，还没有足够的文档来了解DB2 Connect产品的实际工作原理，安装方式或可能的优点。我已经联系了其中的一家经销商进行测试安装，这并不是直观的过程，所以我们从未购买过该产品。同样，似乎没有任何演示。我不明白IBM如何可以使用最好的服务器之一，但是不要向后倒转以将其产品用于Microsoft开发人员。
研究这个主题你会发现很多信息，你可以使用他们的ADO.Net数据服务器提供商使用实体框架。我下了这个路径，但我会警告你，他们的数据服务器提供程序只有在安装DB2连接时才有效。这是令人困惑的，因为IBM广告这种能力，但并不经常显示这两个产品之间的直接关联，所以你经常认为它会在没有db2连接的情况下工作，而目前它不会这样。
2。购买为实体框架设计的第三方数据提供者。 Progress软件的Data Direct是非常易于使用的。我不喜欢他们的服务器许可证的工作原理，因为他们的服务器许可证是每个核心处理器的应用服务器。这是有缺陷的，因为这假设你只有一个应用服务器，实际上，人们经常需要有不同的应用服务器进行负载平衡。我宁愿他们只是每个ISeries服务器的许可证。但是，如果您决定这样做，您可以为每个用户购买许可证。
3。编写自己的数据提供者。这是可能的，但有明显的缺点。
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?
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.
这篇关于使用DB2 iSeries AS / 400可以使用Entity Framework的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
