Oracle 连接的实体数据模型向导崩溃 [英] Entity Data Model Wizard Crash with Oracle Connection

问题描述

我无法使用 VS 2015 为 Oracle 连接创建我的 EDMX 文件.

我使用的是 Visual Studio 2015 更新 3我已经安装了 Oracle Developer Tools 12.1.0.2.4我已经安装了 Oracle Data Access 并且在 client[user]product12.1.0clientodp.netin 下存在以下 DLL2.xOracle.DataAccess.dll 版本:2.121.2.0 ODAC 第 4 版4Oracle.DataAccess.dll 版本:4.121.2.0 ODAC Release 4我正在使用以下程序集Oracle.ManagedDataAccess 版本:4.122.1.0Oracle.ManagedDataAccess.EntityFramework 版本:6.122.1.0* 我相信这两个版本都是基于它们在包文件夹中的文件夹的 12.2.1100 版本.

Server Explorer 中没有定义连接

我的步骤如下:

1. 在解决方案资源管理器中，右键单击项目并选择添加" |新项目..."
2. 选择数据 |ADO.NET 实体数据模型 |添加
3. 从数据库中选择 EF Designer |按下一步

在实体数据模型向导中:

1. 按新连接...(我收到警告找不到默认的 tnsnames.ora 文件."我忽略并按确定"
2. 将数据源设为Oracle 数据库(ODP.NET，托管驱动程序)"，我输入凭据并指定另一个连接参数，然后按测试连接"成功.
3. 我按 OK 并进入实体数据模型向导的下一页
4. 我在连接字符串中包含敏感数据并按下一步....

WIZARD 关闭(崩溃) - 没有创建 EDMX

如果能帮助我解决此问题，我们将不胜感激.

TIA - 泽维尔

解决方案

感谢@Hong-vit 为我指明了正确的方向.我找到了答案.

当您访问

我需要的那个

如您所见，版本号(几乎！)匹配:

• ODAC 12.2.0.1.0 = Oracle.ManagedDataAccess 12.2.1100
• ODAC 12.1.0.2.4 = Oracle.ManagedDataAccess 12.1.24160719(耶！)

我认为这是代表预言机的失败，因为尽管它们包含在一页长自述文件中，但没有明确说明这一点.此外，版本号并不完全相同......但这是博客的咆哮.

I cannot get VS 2015 to create my EDMX file for an Oracle Connection.

I am using Visual Studio 2015 Update 3 I have installed the Oracle Developer Tools 12.1.0.2.4 I have installed Oracle Data Access and the following DLLs exist under client[user]product12.1.0clientodp.netin 2.xOracle.DataAccess.dll version: 2.121.2.0 ODAC Release 4 4Oracle.DataAccess.dll version: 4.121.2.0 ODAC Release 4 I am using the following assemblies Oracle.ManagedDataAccess Version: 4.122.1.0 Oracle.ManagedDataAccess.EntityFramework Version: 6.122.1.0 * I believe both of these are version 12.2.1100 based on the folders in which they reside in the packages folder.

There are no connections defined in the Server Explorer

My steps are as follows:

1. Within the Solutions Explorer, Right click on project and select "Add" | "New Item..."
2. Select Data | ADO.NET Entity Data Model | Add
3. Select EF Designer from Database | Press Next

In the Entity Data Model Wizard:

1. Press New Connection... (I get an warning "Failed to find the default tnsnames.ora file." I ignore and press "OK"
2. With the Datasource as "Oracle Database (ODP.NET, Managed Driver)" I enter the credentials and specify the the other connection parameters and press "Test Connection" which SUCCEEDS.
3. I press OK and am taken to the next page in the Entity Data Model Wizard
4. I include sensitive data in connection string and Press Next....

WIZARD SHUTS DOWN (crashes) - NO EDMX CREATED

Any assistance in helping me troubleshoot this would be greatly appreciated.

TIA - Xavier

解决方案

Thanks to @Hong-vit pointing me in the right direction. I found the answer.

When you visit the download page for ODAC you're given a selection of version numbers.

In my case the top two were:

• ODAC 12.2c Release 1 and Oracle Developer Tools for Visual Studio (12.2.0.1.0)
• ODAC 12c Release 4 and Oracle Developer Tools for Visual Studio (12.1.0.2.4)

For me the top one wouldn't install. It would cut out during the installation process (thanks Oracle!) so I settled with the second one (12.1.0.2.4).

This meant that when I installed Oracle.ManagedDataAccess and Oracle.ManagedDataAccess.EntityFramework I had to select the correct version.

Not for me:

The one I needed

As you can see the version numbers (almost!) match up:

• ODAC 12.2.0.1.0 = Oracle.ManagedDataAccess 12.2.1100
• ODAC 12.1.0.2.4 = Oracle.ManagedDataAccess 12.1.24160719 (yay!)

I believe this is a failing on oracles behalf as it's not made clear despite their inclusion on a page long readme on which this doesn't feature. In additon the version numbers not quite being the same...but that's a rant for the blog.

这篇关于Oracle 连接的实体数据模型向导崩溃的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！