- 382.3K All Categories
- 2.1K Data
- 209 Big Data Appliance
- 1.9K Data Science
- 447.9K Databases
- 220.9K General Database Discussions
- 25 Multilingual Engine
- 520 MySQL Community Space
- 467 NoSQL Database
- 7.8K Oracle Database Express Edition (XE)
- 2.9K ORDS, SODA & JSON in the Database
- 492 SQLcl
- 3.9K SQL Developer Data Modeler
- 186.2K SQL & PL/SQL
- 21K SQL Developer
- 293.3K Development
- 7 Developer Projects
- 128 Programming Languages
- 290K Development Tools
- 95 DevOps
- 3K QA/Testing
- 645.5K Java
- 24 Java Learning Subscription
- 36.9K Database Connectivity
- 149 Java Community Process
- 104 Java 25
- 22.1K Java APIs
- 137.9K Java Development Tools
- 165.3K Java EE (Java Enterprise Edition)
- 16 Java Essentials
- 144 Java 8 Questions
- 85.9K Java Programming
- 79 Java Puzzle Ball
- 65.1K New To Java
- 1.7K Training / Learning / Certification
- 13.8K Java HotSpot Virtual Machine
- 94.2K Java SE
- 13.8K Java Security
- 198 Java User Groups
- 265 LiveLabs
- 36 Workshops
- 10.2K Software
- 6.7K Berkeley DB Family
- 3.5K JHeadstart
- 5.8K Other Languages
- 2.3K Chinese
- 166 Deutsche Oracle Community
- 1.2K Español
- 1.9K Japanese
- 229 Portuguese
Problems with Entity Framework wizard disappearing
If you are using Entity Framework and using ODP.NET in your project (from Nuget), please use the same major version of Oracle Developer Tools for Visual Studio (ODT) and ODP.NET.
For example, if you have ODT 19.3, then please use ODP.NET 19.x. If you have ODT 18.3, use ODP.NET 18.x.
In the most recent ODT 19.3 we have a bug that also causes the EF designer to disappear.
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
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
This will avoid the crash and allow the EF model to be added to your project, but please be aware that ODP.NET will not automatically be able to find the location of your tnsnames.ora and wallet files. You will need to set TNS_ADMIN and (if needed) WALLET_LOCATION in the config file (eg app.config, or web.config) or include the TNSNAMES/SQLNET.ORA/WALLET/etc in the root of your project. In future releases these values will be set in the ODP.NET connection string automatically and you will not have to do this.