ADO.Net 链接 Oracle 数据库

链接本地数据库：

Data Source=MyOracleDB;User Id=myUsername;Password=myPassword;
Integrated Security=no;

链接远程数据库：

        static void Main(string[] args)
        {
            string conStr = @"SERVER=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=IP地址)(PORT=端口号))(CONNECT_DATA=(SERVICE_NAME=监听服务)));
uid=用户名;pwd=密码;";
            OracleConnection oracleConn = new OracleConnection(conStr);
//oracleConn.ConnectionString =@"User Id=system;Password=123456;
//                                     Data Source=oracleSN;";
            oracleConn.Open();
            OracleCommand cmd = new OracleCommand("select * from \"UserInfo\"", oracleConn);
            DataSet ds = new DataSet();
            OracleDataAdapter da = new OracleDataAdapter(cmd);
            da.Fill(ds);

            oracleConn.Close();
        }