Code: Select all
IList homes = OracleConnection.Homes;
OracleHome home1 = (OracleHome)homes[0];
OracleHome home2 = (OracleHome)homes[1];
string db1 = home1.GetServerList()[0];
string db2 = home2.GetServerList()[0];
using (OracleConnection db1Conn = new OracleConnection {Home = home1.Name, Server = db1, UserId = "xxxx", Password = "xxxx"}) {
db1Conn.Open();
}
using (OracleConnection db2Conn = new OracleConnection {Home = home2.Name, Server = db2, UserId = "xxxx", Password = "xxxx"}) {
db2Conn.Open();
}