C#连接oracle数据库

using System;
using System.Data;
using System.Data.OracleClient;

namespace ConnectionToOracle
... {
classProgram
...{
staticvoidMain(string[]args)
...{
OracleBDUtilityoracle=newOracleBDUtility();
oracle.getData();
}
}

publicclassOracleBDUtility
...{
OracleConnectionConn=newOracleConnection("server=joe;userid=scott;password=tiger");
publicvoidgetData()
...{
Conn.Open();
OracleCommandcmd=Conn.CreateCommand();
cmd.CommandText="selectename,jobfromscott.empwherejobisnotnull";
OracleDataReaderodr=cmd.ExecuteReader();
while(odr.Read())
...{
Console.WriteLine("{0}--{1}",odr.GetValue(0),odr.GetValue(1));
}
odr.Close();
Conn.Close();
}
}
}