OracleDataSourceEnumerator Class
Provides a mechanism for enumerating all known Oracle servers (TNS aliases).
This sample shows the use of OracleDataSourceEnumerator class.
|
|---|
OracleHomeCollection homes = OracleConnection.Homes;
foreach (OracleHome h in homes) {
Console.WriteLine("=== Home={0} ===", h.Name);
OracleDataSourceEnumerator en = new OracleDataSourceEnumerator();
DataTable tbl = en.GetDataSources(h.Name);
foreach (DataRow row in tbl.Rows) {
Console.WriteLine(row["InstanceName"]);
}
}
Console.ReadLine(); |
|
|---|
Dim homes As OracleHomeCollection = OracleConnection.Homes
For Each h As OracleHome In homes
Console.WriteLine("=== Home={0} ===", h.Name)
Dim en As New OracleDataSourceEnumerator()
Dim tbl As DataTable = en.GetDataSources(h.Name)
For Each row As DataRow In tbl.Rows
Console.WriteLine(row("InstanceName"))
Next
Next
Console.ReadLine() |
