.NET 操作Oracle（使用Oracle.ManagedDataAccess）

1、确认你有oracle的访问权限

2、NuGet 安装 Oracle.ManagedDataAccess

3、配置写上连接

  <connectionStrings>
    <add name="ConnectOracle" connectionString="Data Source=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=主机IP)(PORT=1521)) (CONNECT_DATA=(SERVICE_NAME/SID=服务名/SID)));User ID=用户名;Password=密码;" providerName="System.Data.OracleClient" />
  </connectionStrings>

4、CURD

public static OracleDataReader ExecuteReader(string strSQL)
        {
            OracleConnection connection = new OracleConnection(connectionString);
            OracleCommand cmd = new OracleCommand(strSQL, connection);
            try
            {
                connection.Open();
                OracleDataReader myReader = cmd.ExecuteReader(CommandBehavior.CloseConnection);
                return myReader;
            }
            catch (OracleException e)
            {
                throw new Exception(e.Message);
            }

        }

以上。