Oracle Managed and TNS Names
Hi Alex,
First great session yesterday, it's look like very promising, what I missed was a performance comparison between Managed and Unmanaged provider.
For tnsnames.ora file, as I understood the paths where the managed client is looking for tnsnames.ora are in follow order:
1. Working directory.
2. Path defined in app.config, web.config, machine.config
There should be two more locations:
3: Path defined by TNS_ADMIN env. variable
4 ORACLE_HOME/network/admin path
If you don't want to support TNS_ADMIN and ORACLE_HOME, there should be a public class for parsing tnsnames.ora. Then if I want to use ORACLE_HOME I can find myself the tnsnames.ora file and parse it using this api.