Oracle链接数据库 .net

 1.首先去下载Oracle驱动oracle_net.msi

2.安装完之后在项目里面引用system.data.oracleclient

3.链接数据库的GetConnection类如下： 

public class GetConnection
    {
      private static OracleConnection _connection;
      /// <summary>
      /// 获取数据库连接桥
      /// </summary>
      private static OracleConnection Connection
        {
            get
            {
                //Data Source=orcl_169;User ID=openeap;Password=***********;Unicode=True
               string connectionString = ConfigurationManager.AppSettings["ConnectionString"];
              // string connectionString = "Data Source=.;Initial Catalog=shopping;Persist Security Info=True;User ID=dkj;Password=dkj123456";
                //string connectionString = "Data Source=.;Initial Catalog=shopping;Integrated Security=True";;dkj/dkj123456
                if (_connection == null)
                {
                    _connection = new OracleConnection(connectionString);
                    _connection.Open();
                }
                if (_connection.State == ConnectionState.Closed)
                {
                    _connection.Open();
                }
                if (_connection.State == ConnectionState.Broken)
                {
                    _connection.Close();
                    _connection.Open();
                }
                return GetConnection._connection;
            }
         
        }
      /// <summary>
      /// 获取表数据
      /// </summary>
      /// <param name="sql"></param>
      /// <returns></returns>
      public static OracleDataReader GetDataRead(string sql)
        {
            OracleCommand command = new OracleCommand(sql, Connection);
            OracleDataReader read = command.ExecuteReader();
            return read;
        }
        public static int NoSelect(string sql)
        {
            OracleCommand command = new OracleCommand(sql, Connection);
            int row = command.ExecuteNonQuery();
            return row;
        }
        public static DataTable GetDataTable(string sql)
        {
            OracleCommand command = new OracleCommand(sql, Connection);
            DataTable dt = new DataTable();
            OracleDataAdapter sda = new OracleDataAdapter(command);
            sda.Fill(dt);
            return dt;
        }
        /// <summary>
        /// 执行sql语句，返回一行一列。。
        /// </summary>
        /// <param name="sql">SQL语句</param>
        /// <returns></returns>
        public static string GetScalar(string sql)
        {
            OracleCommand command = new OracleCommand(sql, Connection);
            return command.ExecuteScalar().ToString();
        }

    }