Discussions
Categories
- 196.8K All Categories
- 2.2K Data
- 238 Big Data Appliance
- 1.9K Data Science
- 450.3K Databases
- 221.7K General Database Discussions
- 3.8K Java and JavaScript in the Database
- 31 Multilingual Engine
- 550 MySQL Community Space
- 478 NoSQL Database
- 7.9K Oracle Database Express Edition (XE)
- 3K ORDS, SODA & JSON in the Database
- 544 SQLcl
- 4K SQL Developer Data Modeler
- 187K SQL & PL/SQL
- 21.3K SQL Developer
- 295.8K Development
- 17 Developer Projects
- 138 Programming Languages
- 292.5K Development Tools
- 107 DevOps
- 3.1K QA/Testing
- 646K Java
- 28 Java Learning Subscription
- 37K Database Connectivity
- 154 Java Community Process
- 105 Java 25
- 22.1K Java APIs
- 138.1K Java Development Tools
- 165.3K Java EE (Java Enterprise Edition)
- 18 Java Essentials
- 160 Java 8 Questions
- 86K Java Programming
- 80 Java Puzzle Ball
- 65.1K New To Java
- 1.7K Training / Learning / Certification
- 13.8K Java HotSpot Virtual Machine
- 94.3K Java SE
- 13.8K Java Security
- 204 Java User Groups
- 24 JavaScript - Nashorn
- Programs
- 437 LiveLabs
- 38 Workshops
- 10.2K Software
- 6.7K Berkeley DB Family
- 3.5K JHeadstart
- 5.7K Other Languages
- 2.3K Chinese
- 171 Deutsche Oracle Community
- 1.1K Español
- 1.9K Japanese
- 232 Portuguese
VS 2019 - Problems with Entity Framework wizard disappearing

I am using the shiny new ODT 19.3 via VS 2019.
When ever I try to open the Entity Framework wizard to create a model from a existing DB the wizard closes without any feedback.
Steps:
1. Add new ADO.NET Entity Data Model
2. EF Designer from database
3. Choose Your Data Connection and click Next
4. BOOM
I am using the following Nuget Packages:
- "Oracle.ManagedDataAccess" version="19.6.0"
- "Oracle.ManagedDataAccess.EntityFramework" version="19.6.0"
Microsoft Visual Studio Community 2019
Version 16.4.4
Are there any ODT logfiles? and if so where?
Thanks
Best Answer
-
Thank you!
We have one workaround for this issue now - if the TNSNAMES.ORA and wallet files are located in the default location this error will not occur.
On installation, the default location is %USERPROFILE%\Oracle\network\admin. The default is also changeable in the options page.
So, you can do one of two things:
1) Backup contents of %USERPROFILE%\Oracle\network\admin, then delete the contents of this directory.
2) Copy the tnsnames.ora, sqlnet.ora and wallet files to this location
3) Restart Visual Studio
Or
1) Go to VS menu, Tools->Options->Oracle Developer Tools ->Connection Configuration and set Tns admin location to the location you want to connect from. Also set wallet file location as well.
2) Restart Visual Studio
Answers
-
I was getting the same issue!
But I was using the following Nuget Packages:
- "Oracle.ManagedDataAccess" version "18.3"
- "Oracle.ManagedDataAccess.EntityFramework" version "18.3"
- "EntityFramework" version "6.1.3"
Microsoft Visual Studio Professional 2019 version 16.4.5
ODT 19.3 via Tools for Visual Studio 2019 version 19.3
Exact same issue you were having.
I then updated
"Oracle.ManagedDataAcces" to version "19.6"
"Oracle.ManagedDataAccess.EntityFramework" to version "19.6"
This got me a new page on Step three of the steps in OP's post, but it basically said EntityFramework is out of date.
Sorry I didn't get a screen grab.
I then updated
"EntityFramework" to version "6.4.0"
And it is now working. Luckily this project is relatively new and I have the ability to update everything to the latest.
packages.config
<?xml version="1.0" encoding="utf-8"?>
<packages>
<package id="EntityFramework" version="6.4.0" targetFramework="net48" />
<package id="Oracle.ManagedDataAccess" version="19.6.0" targetFramework="net48" />
<package id="Oracle.ManagedDataAccess.EntityFramework" version="19.6.0" targetFramework="net48" />
</packages>
-
Sorry, but as hard I try I can't get this to work.
I tested all kind of combinations:
EntityFramework (6.0 to 6.4) and Oracle.ManagedDataAccess (18.3 to 19.6)
Also updated the target .Net Framework to 4.8.
My package config:
Used also a separate fresh machine with the latest Visual Studio Version Community (16.4.5).
Maybe it has to do with the connection. I am using a connection to a ATP Cloud Instance:
I also tested with a normal paid cloud instance.
@Christian.Shay -Oracle Can someone please provide a working sample:
Oracle.ManagedDataAccess.EntityFramework connected to ATP Always Free DB Instance
Thanks
-
I use
Microsoft Visual Studio Professional 2019
Version 16.4.5
Oracle database 11g.
I tried EF 6.1.3 , 6.2 , .6.4
- "Oracle.ManagedDataAccess" from version "12." to the newest
- "Oracle.ManagedDataAccess.EntityFramework" from version "12.x" to the newest.
Many combinations. All of them don't work .
Any ideas what to do ?
-
I'm having the same problem. We are developing a web application in VS2013 and are moving over to VS2019 and when I try and go to the .edmx diagram, right click and select 'Update Model From Database', select the connection and click 'Next' it tries to open a screen to select a version of Entity Framework, but then crashes. I've got the following
VS2019 Professional 2019 Version 16.4.5
Entity Framework Version 6.0.0.0
Oracle Developer Tools 19.3 which contains :-
Oracle Managed Data Access Version 4.122.19.1
Oracle Managed Data Access Entity Framework Version 6.122.19.1
We are using Oracle Version 12.1 as the database
I've tried deleting the old version of the Oracle packages from VS2013 and just having the ones from VS2019, changing the machine.config file, changing the web.config, changing the app.config, but nothing seems to be working. Could someone at Oracle please look into this, because there is clearly a major issue with this and it is going to be affecting a lot of people
-
I also tested ODT 19.3 + Visual Studio 2017.
With the same result: The entity framework wizard disappears next to the "Choose Your Data Connection" step.Please Oracle, help us and provide a solution!
-
Hi all,
Thanks for all your help raising this issue. We are working with Microsoft to try to resolve it. As soon as I have a workaround or more information, I will post again here to let you know.
Thanks,
Christian
-
4141867 wrote:I am using the shiny new ODT 19.3 via VS 2019.When ever I try to open the Entity Framework wizard to create a model from a existing DB the wizard closes without any feedback.Steps:1. Add new ADO.NET Entity Data Model2. EF Designer from database3. Choose Your Data Connection and click Next4. BOOM
I am using the following Nuget Packages:
- "Oracle.ManagedDataAccess" version="19.6.0"
- "Oracle.ManagedDataAccess.EntityFramework" version="19.6.0"
Microsoft Visual Studio Community 2019
Version 16.4.4
Are there any ODT logfiles? and if so where?
Thanks
Hi,
Could you please let me know the following?
1) Is the Server Explorer connection using TNS alias or Basic (ezconnect) for the connection ?
2) If the Server Explorer connection is using TNSAlias, is it using tnsnames.ora from the default location (%USERPROFILE%\Oracle\network\admin) ? Or is it in some other location?
-
Hi Christian, thanks for helping out.
1) Is the Server Explorer connection using TNS alias or Basic (ezconnect) for the connection ?
- It is using "TNS Alias":
2) If the Server Explorer connection is using TNSAlias, is it using tnsnames.ora from the default location (%USERPROFILE%\Oracle\network\admin) ? Or is it in some other location?
- As u can see it uses: "%USERPROFILE%\Oracle\network\admin\AlwaysFreeDB2"
There is a tnsnames.ora with the following connection string:alwaysfreedb2_high = (description= (retry_count=20)(retry_delay=3)(address=(protocol=tcps)(port=1522)(host=adb.eu-frankfurt-1.oraclecloud.com))(connect_data=(service_name=aklhtl00etaacqi_alwaysfreedb2_high.atp.oraclecloud.com))(security=(ssl_server_cert_dn="CN=adwc.eucom-central-1.oraclecloud.com,OU=Oracle BMCS FRANKFURT,O=Oracle Corporation,L=Redwood City,ST=California,C=US")))
I also tested the same setup with an Oracle 11g instance using EZConnect and it is working.
As far as I know u can't use an ATP instance with "EZConnect"?
Thanks,
Andreas -
Thank you!
We have one workaround for this issue now - if the TNSNAMES.ORA and wallet files are located in the default location this error will not occur.
On installation, the default location is %USERPROFILE%\Oracle\network\admin. The default is also changeable in the options page.
So, you can do one of two things:
1) Backup contents of %USERPROFILE%\Oracle\network\admin, then delete the contents of this directory.
2) Copy the tnsnames.ora, sqlnet.ora and wallet files to this location
3) Restart Visual Studio
Or
1) Go to VS menu, Tools->Options->Oracle Developer Tools ->Connection Configuration and set Tns admin location to the location you want to connect from. Also set wallet file location as well.
2) Restart Visual Studio
-
Hi Christian,
Thank you for providing this workaround. It works just fine.
I tested some simple scenarios (create & update model from ATP database) without any problems.The same applies to ODT 19.6 for Visual Studio 2017.
Thanks again and best regards
Andreas