This is really a continuation of
However, since that discussion has been deemed to be 'answered', it appears I cannot add to it.
The fact is the proposed solution does not work
I have Visual Studio 2019 (16.7.2)
I have ODAC 18.3 installed (ODTwithODAC183)
I created a C# console application (.NET Framework) - n.b. NOT .NET Core
I installed the following nuget packages
OracleManagedDataAccess (v18.3.0)
OracleManagedDataAccess.EntityFramework (v18.3.0) - this install also brought in EntityFramework (v6.0.0)
Now, I had oracle already 18 already installed, and tnsnames was installed in:
c:\app\johnm\product\18.0.0\dbhomeXE\Network\Admin\tnsnames.ora
when I installed ODAC, it created a new tnsnames which resides in:
C:\app\client\johnm\product\18.0.0\client_1\Network\Admin
The earlier post talks about tnsnames and other files should be present in %USERPROFILE%\Oracle\network\admin
I've put copies of tnsmaes.ora, in (C:\Users\johnm\Oracle\network\admin) but it doesn't make any differences whatsover.
I even added a system variable of TNS_ADMIN and changed it to all 3 paths, and still doesn't work.
As soon as you get to the point of selecting entity framework 6, the wizard does not come up and instead immediately returns to the 'Add New Item' dialog box.
What else do I need to do? This is ridiculous. You should be able to setup Entity Framework in 5 minutes, not days.
Any help much appreciated.
Christian, your answer of the following does NOT work
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