ManagedDataAccess连数据库

Oracle官方的托管数据库访问组件，单DLL，Oracle.ManagedDataAccess.dll，不安装Oracle客户端，不区分32/64位， 直接引用即可。

与非托管程序为Oracle.DataAccess.dll相比，不支持BulkCopy和CustomType等。

下载

https://www.oracle.com/database/technologies/odac-downloads.html

或者

nuget

文档

https://docs.oracle.com/cd/E11882_01/win.112/e23174/toc.htm

DataSet接收

            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);
            }