一.推荐使用Oracle.ManagedDataAccess.dll
1.连接Oracle数据库,打开连接
连接字符串在config文件中的形式为
Data Source=(Oracle =(DESCRIPTION =(ADDRESS = (PROTOCOL = TCP)(HOST = 0.0.0.0)(PORT = 0000))(CONNECT_DATA =(SERVER = DEDICATED)(SERVICE_NAME = Name)))); Persist Security Info=True;User ID=uid;Password=pwd;
public static OracleConnection OpenConn()
{
try
{
var conString = Util.GetXmlConfig("JdeDbCon");//获取config 文件中的连接字符串
OracleConnection conn = new OracleConnection();
conn.ConnectionString = conString;
conn.Open();
return conn;
}
catch (Exception e)
{
throw new Exception(e.Message);
}
}
2.数据库操作结束后关闭连接