http://www.cnblogs.com/gguozhenqian/p/4262813.html
操作步骤:
1.DLL下载后并引用
下载地址:Oracle.ManagedDataAccess.zip
下载后,将Oracle.ManagedDataAccess.dll放到自己的项目中,然后引用
2.直接调用(connString 改为自己的连接字符串)
using Oracle.ManagedDataAccess.Client;
public static string ConnectOracle()
{
try
{
string connString = "Data Source=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=130.147.246.144)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=ECMS)));Persist Security Info=True;User ID=system;Password=Service01;";
OracleConnection con = new OracleConnection(connString);
con.Open();
return string.Empty;
}
catch (Exception ex)
{
return ex.ToString();
}
}