从 DB2 数据库生成 EDMX_C#/.NET开发问题-跟版网

本文介绍了从 DB2 数据库生成 EDMX的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着跟版网的小编来一起学习吧！

问题描述

我正在尝试使用 VS2013 创建一个 EDMX 文件，以便可以从 DB2 数据库读取/写入.我经历了与从我的 SQL 表创建 EDMX 相同的过程(右键单击项目 -> 添加新项目 -> ADO.NET 实体数据模型 -> 数据库中的 EF 设计器 -> 这次不使用 SQL:新连接 -> 更改数据源)但在数据源选项中，DB2 不可用.我有 2 个 SQL 选项，仅此而已.

I'm trying to create an EDMX file using VS2013 so I can read/write from a DB2 Database. I go through the same process as creating the EDMX from my SQL tables (Right click on project -> Add New Item -> ADO.NET Entity Data Model -> EF Designer from database -> Not using SQL this time so: new connection -> Change data source) but in the Data Source option, DB2 is not available. I have 2 SQL options and that's it.

数据源

因此，在对这里和其他一些地方进行了一些调查之后，在 EF6 插件问世之前，似乎 EF 并未真正设置为执行此操作.因此，我使用 Nuget 安装了 EntityFramework.IBM.DB2 版本 6.0.3，希望这会为我的数据源区域添加一些内容，让我可以选择 DB2 数据库，但仍然没有.

So after doing some investigating around here along with some other places, it looks like EF wasn't actually setup to do this until a plugin for EF6 came out. So using Nuget I have installed EntityFramework.IBM.DB2 version 6.0.3 hoping that would add something to my Data Source area allowing me to choose a DB2 database but still nothing.

我会尽量在这里提供尽可能多的关于我的系统的信息，所以如果我漫不经心……我倾向于这样做……提前抱歉.

I'm gonna try to give as much info about my system here as I know so if I ramble...which I tend to do...sorry in advance.

我在使用 VS2013 专业版的 Windows 7 上.我有一个 ODBC 连接设置，多年来一直运行良好.我可以进入 ODBC 管理器并测试我与测试和生产 DB2 的连接，它连接得很好.

I'm on Windows 7 using VS2013 Pro edition. I have an ODBC connection setup and it's been working great for years. I can go into the ODBC Manager and test my connection to both Test and Production DB2 and it connects just fine.

ODBC 数据源管理器的版本是 6.1.7601.17632，我使用的是 IBM DB2 ODBC 驱动程序...看起来它的版本是 10.5.500(尽管我不能 100% 确定我是否在寻找正确的获取该版本号的地方)

The ODBC Data Source Administrator is version 6.1.7601.17632 and I'm using the IBM DB2 ODBC Driver...looks like it's version 10.5.500 (although I'm not 100% sure if I'm looking in the right place to get that version number)

我还可以进入 Access 并使用 ODBC 连接连接到 DB2 数据库，然后返回表及其数据.

I can also go into Access and connect to the DB2 databases using the ODBC connection and bring back the tables and their data.

我还可以使用连接字符串设置(我假设使用相同的 ODBC 连接)将 SQL 语句直接写入我的代码，并从 SQL 读取数据并调用连接到这些 DB2 表的存储过程来写入/更新/删除.

I can also write SQL statements directly into my code with the connection string setup (that I assume uses that same ODBC connection) and reads data from SQL and calls Stored Procedures connected to those DB2 tables to write/update/delete.

最后，似乎以前的同事能够完成这项工作.我已经加载了他的代码，当我打开 EDMX 时，我得到了所有表格的漂亮图形显示.但是当我尝试点击从数据库更新时，我得到一个错误:

Lastly, it seems like a previous coworker was able to make this work. I have loaded his code and when I pull up the EDMX, I get the nice graphical display of all the tables. But when I try to click Update from Database, I get an error:

错误信息

很遗憾，他已经不在公司了，他的电脑也不是我可以查看的状态.

Sadly, he is no longer with the company and his computer is not in a condition where I can take a look at it.

所以感觉这是可以完成的事情，而且我的计算机几乎已设置为可以执行此操作...除了我缺少的一些东西，它允许我首先将那个 DB2 类型的数据源添加到那个上图，这样我就可以选择它，放入凭据并继续前进.

So it feels like this is something that can be done and that my computer is almost setup to do this...with the exception of something I'm missing that will allow me to add that DB2 type data source to that first image above so I can select it, put the credentials in and move on.

任何帮助将不胜感激......

Any help will be truly appreciated...

从 DB2 数据库生成 EDMX

问题描述

推荐答案

相关文档推荐