.NET链接Oracle的方法oracle
方式1:直接利用.NET的oracle驱动链接ide
引用System.data.oracleclient;.net
using System.data.oracleclient;string
string oradb = "Data Source=water;User Id=modis;Password=modis;Integrated Security=no";it
OracleConnection conn = new OracleConnection(oradb);io
conn.Open();cli
方式2:安装完ODP.net(Oracle Data Provider.NET),经过OLEDB链接。引用
引用System.Data.OleDb;方法
using System.Data.OleDb;db
string oradb = "Provider=OraOLEDB.Oracle;Data Source=water;User Id=modis;Password=modis;";
OleDbConnection myConnection = new OleDbConnection(oradb);
myConnection.Open();
方式3:安装完ODP.net,经过Oracle的链接器
引用动态连接库Oracle.DataAccess.Client.
using Oracle.DataAccess.Client;
string oradb = "Data Source=water;User Id=modis;Password=modis;";
OracleConnection conn = new OracleConnection(oradb); // C#
conn.Open();