C#连接Oracle数据库

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

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

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

4、连接数据库代码如下：

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;

            }

}