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]\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
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 - NO EDMX CREATED
Any assistance in helping me troubleshoot this would be greatly appreciated.
TIA - Xavier