Enumerating Oracle Database names for a specified server

Question

How can I enumerate Oracle Database names in C#?

I am able to query all available databases for a MSSQL connection string:

using (var con = new SqlConnection("Password=TestPassword;User ID=TestUser;Data Source=localhost"))
{
    con.Open();

    return con.GetSchema("Databases")
                .Rows.Cast<DataRow>()
                .Select(row => row.Field<string>("database_name"))
                .ToList();
}

Answer 1

If you are using ODP.NET, you can use the OracleDataSourceEnumerator to list the TNS entries. See the documentation here.

If not then you'll have to parse the tnsnames.ora yourself.