I downloaded Oracle.ManagedDataAccess.Core 2.19.1 for .Net.
At first, I tried OracleConfiguration.OracleDataSources.Add() and I was able to establish the connection.
I, then, tried to experiment with OracleConfiguration.TnsAdmin thinking if I can get this to work, I don't have to add the DataSources one by one (we have a lot).
Unfortunately, TnsAdmin did not work. I got this error: ORA-12154: TNS:could not resolve the connect identifier specified
Am I missing something or this feature does not work?
P.S. I tried to find the docs, but no luck.
According to Oracle, there's a bug with OracleConfiguration that prevents TnsAdmin from using the hidden share in Windows, i.e. \server\share$.
The bug number is: 29956349