I installed Oracle Developer Tools for Visual Studio 2019 (ODTforVS2019_193100.vsix).
From VS2019 Server Explorer I can easily connect to our Oracle DB.
But when running the application from Debugger (and also outside) I Always get the Error ORA-12154: TNS:could not resolve the connect identifier specified .
I tried a lot of things but in vein.
I found out that web.config has the highest precendence. Therefore I put the Setting TNS_ADMIN in referencing the Folder of my tnsnames.ora:
<oracle.manageddataaccess.client>
<version number="4.122.19.1">
<settings>
<setting name="TNS_ADMIN" value="C:\Oracle\Network\Admin" />
</settings>
</version>
</oracle.manageddataaccess.client>
In the Trace-File the TNSNAMES file is still null:
...
2020-04-03 16:09:05.724385 TID:58 (CFG) (ENV) Application Directory : C:\APL\MVC\Projekte2\Novemberbrief\Kendo_2020.1\_apl
2020-04-03 16:09:05.724385 TID:58 (CFG) (VER) Oracle Data Provider for .NET, Managed Driver Version : 4.122.19.1
2020-04-03 16:09:05.725383 TID:58 (CFG) (VER) Oracle Data Provider for .NET, Managed Driver Informational Version : 4.122.19.1:20191122
2020-04-03 16:09:05.725383 TID:58 (CFG) (.NET) TraceLevel : 7
2020-04-03 16:09:05.725383 TID:58 (CFG) (.NET) TNS_ADMIN : C:\Oracle\Network\Admin
2020-04-03 16:09:05.725383 TID:58 (CFG) (.NET) names.default_domain : win.ch
2020-04-03 16:09:05.725383 TID:58 (CFG) (.NET) TraceOption : 1
2020-04-03 16:09:05.725383 TID:58 (CFG) (.NET) NAMES.DIRECTORY_PATH : (TNSNAMES)
2020-04-03 16:09:05.725383 TID:58 (CFG) (.NET) TraceFileLocation : C:\temp\Oracle\Traces
2020-04-03 16:09:05.725383 TID:58 (CFG) (.NET) Resolved Trace File Location: C:\temp\Oracle\Traces
2020-04-03 16:09:05.725383 TID:58 (CFG) (SQLNET) FilePath : C:\Oracle\Network\Admin\sqlnet.ora
2020-04-03 16:09:05.725383 TID:58 (CFG) (TNSNAMES) FilePath : (null)
2020-04-03 16:09:05.714412 TID:58 (PUB) (ENT) OracleConnection.Open() (conid=2589303) (state=Closed) (sessid=0) (implid=0) (pooling=T) (txnid=n/a)
...
2020-04-03 16:09:05.973342 TID:58 (PRI) (ERR) (CP) PoolManager.CreateNewPR() (txnid=n/a) Oracle.ManagedDataAccess.Client.OracleException (0x80004005): ORA-12154: TNS: Angegebener Connect Identifier konnte nicht aufgelöst werden ---> OracleInternal.Network.NetworkException (0x00002F7A): ORA-12154: TNS: Angegebener Connect Identifier konnte nicht aufgelöst werden
bei OracleInternal.Network.AddressResolution..ctor(String TNSAlias, SqlNetOraConfig SNOConfig, Hashtable ObTnsHT, String instanceName, ConnectionOption CO)
bei OracleInternal.Network.OracleCommunication.Resolve(String tnsAlias, ConnectionOption& CO)
bei OracleInternal.ConnectionPool.PoolManager`3.ResolveTnsAlias(ConnectionString cs, Object OC)
bei OracleInternal.ServiceObjects.OracleConnectionImpl.Connect(ConnectionString cs, Boolean bOpenEndUserSession, OracleConnection connRefForCriteria, String instanceName)
bei OracleInternal.ConnectionPool.PoolManager`3.CreateNewPR(Int32 reqCount, Boolean bForPoolPopulation, ConnectionString csWithDiffOrNewPwd, OracleConnection connRefForCriteria, String instanceName, List`1 switchFailedInstNames)