操作步骤:
- DLL下载后并引用
下载地址:Oracle.ManagedDataAccess.zip
下载后,将Oracle.ManagedDataAccess.dll放到自己的项目中,然后引用
- 直接调用(connString 改为自己的连接字符串)
1234567891011121314151617using
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();
}
}
就是这么简单!!!