C# 免客户端访问Oracle的DLL
代码示例:
OracleConnection con = new OracleConnection();
con.ConnectionString ="user id=username;password=password;data source=(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=localhost)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=servicename.oracle.com)))";
con.Open();
OracleCommand cmd = new OracleCommand();
cmd.CommandType = System.Data.CommandType.Text;
cmd.CommandText = "select * from students";
cmd.Connection = con;
OracleDataAdapter da = new OracleDataAdapter();
da.SelectCommand = cmd;
DataSet ds = new DataSet();
da.Fill(ds);
con.Close();
da.Dispose();
cmd.Dispose();
con.Dispose();
注:
C#的版本要求 .NET Framework 4.0才能引入这个DLL文件,否则会报错
DLL文件下载地址(64位):https://pan.baidu.com/s/17qm0ooNvP2ZHAOHYVUV0-g
Enjory :)