ManagedDataAccess连数据库

            DataSet ds = new DataSet();
            string str = @"Data Source=xxx:1521/orcl; User Id=xxx; password=xxx;Pooling=false";
            string sql = "select * from T_MD_SCALE";
            try
            {
                using (OracleConnection conn = new OracleConnection(str))
                {
                    conn.Open();
                    if (conn.State == ConnectionState.Open)
                    {
                        OracleDataAdapter da = new OracleDataAdapter(sql, conn);
                        da.Fill(ds, "ds");
                    }
                    //测试
                    Console.ReadKey();
                }
            }
            catch (Exception ex)
            {
                Console.WriteLine(ex.Message);
            }