C#连接Oracle 11g数据库

1. 原文网址：C#连接 Oracle数据库

2. 1.下载“Oracle.ManagedDataAccess.dll”；

3. 2.在工程中添加引用“Oracle.ManagedDataAccess.dll”；

4. 3.引用命名空间“using Oracle.ManagedDataAccess.Client;”

5. 4.连接数据库代码如下：

6. public bool Connect(string hostaddress, string servername, string uid, string pwd)

   {

              string connString = "Data Source=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST="+ hostaddress +")(PORT=1521))(CONNECT_DATA=(SERVICE_NAME="+ servername +")));Persist Security Info=True;User ID="+ uid +";Password="+ pwd +";";

               OracleConnection conn = new OracleConnection(connString);

               conn.Open();

               if(conn.State==ConnectionState.Open)

               {

                   conn.Close();

                   return true;

               }

               else

               {

                   return false;

               }

   }

7. 5.下载Oracle.ManagedDataAccess.dll链接：http://pan.baidu.com/s/1sjzc3W5