使用Oracle连接的实体数据模型向导崩溃 [英] Entity Data Model Wizard Crash with Oracle Connection
问题描述
我无法使用VS 2015为Oracle Connection创建EDMX文件.
I cannot get VS 2015 to create my EDMX file for an Oracle Connection.
我正在使用Visual Studio 2015 Update 3 我已经安装了Oracle Developer Tools 12.1.0.2.4 我已经安装了Oracle Data Access，并且\ client [user] \ product \ 12.1.0 \ client \ odp.net \ bin下存在以下DLL. 2.x \ Oracle.DataAccess.dll版本:2.121.2.0 ODAC版本4 4 \ Oracle.DataAccess.dll版本:4.121.2.0 ODAC版本4 我正在使用以下程序集 Oracle.ManagedDataAccess版本:4.122.1.0 Oracle.ManagedDataAccess.EntityFramework版本:6.122.1.0 *我相信这两个都是基于packages文件夹中驻留的文件夹的12.2.1100版本.
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]\product\12.1.0\client\odp.net\bin 2.x\Oracle.DataAccess.dll version: 2.121.2.0 ODAC Release 4 4\Oracle.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
我的步骤如下:
- 在解决方案资源管理器中，右键单击项目，然后选择添加" |添加". 新项目..."
- 选择数据| ADO.NET实体数据模型|添加
- 从数据库中选择EF设计器|按下一步
在实体数据模型向导中:
In the Entity Data Model Wizard:
- 按新建连接..."(我收到警告找不到默认的tnsnames.ora文件."我忽略并按确定"
- 使用"Oracle数据库(ODP.NET，托管驱动程序)"作为数据源时，我输入凭据并指定另一个 连接参数，然后按SUCCEEDS中的测试连接".
- 我按确定"，然后转到实体数据模型向导"中的下一页
- 我在连接字符串中包含敏感数据，然后按Next ....
- Press New Connection... (I get an warning "Failed to find the default tnsnames.ora file." I ignore and press "OK"
- 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.
- I press OK and am taken to the next page in the Entity Data Model Wizard
- I include sensitive data in connection string and Press Next....
向导关闭(崩溃)-未创建EDMX
在帮助我解决此问题方面的任何帮助将不胜感激.
Any assistance in helping me troubleshoot this would be greatly appreciated.
TIA-Xavier
TIA - Xavier
推荐答案
感谢@ Hong-vit向我指出正确的方向.我找到了答案.
Thanks to @Hong-vit pointing me in the right direction. I found the answer.
当您访问 ODAC下载页面时，您会重新选择了版本号.
When you visit the download page for ODAC you're given a selection of version numbers.
就我而言，前两个是:
- ODAC 12.2c第1版和适用于Visual Studio的Oracle开发人员工具( 12.2.0.1.0 )
- ODAC 12c第4版和适用于Visual Studio的Oracle开发人员工具( 12.1.0.2.4 )
- 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)
对我来说，排名第一的将不会安装.它会在安装过程中中断(感谢Oracle！)，所以我选择了第二个( 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).
这意味着当我安装Oracle.ManagedDataAccess和Oracle.ManagedDataAccess.EntityFramework时，必须选择 正确的版本 .
This meant that when I installed Oracle.ManagedDataAccess and Oracle.ManagedDataAccess.EntityFramework I had to select the correct version.
不适合我
我需要的那个
您可以看到版本号(差不多！)匹配:
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 (是！)
- ODAC 12.2.0.1.0 = Oracle.ManagedDataAccess 12.2.1100
- ODAC 12.1.0.2.4 = Oracle.ManagedDataAccess 12.1.24160719 (yay!)
我认为这对Oracle来说是一个失败，因为尽管它们包含在长达一页的自述文件中，但没有明确说明，但尚不清楚.此外，版本号也不尽相同...但这对博客来说是很麻烦的.
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屋！
