oracle.dataaccess 连接池,asp.net使用Oracle.DataAccess.dll连接Oracle-白红宇

oracle.dataaccess 连接池,asp.net使用Oracle.DataAccess.dll连接Oracle

阅读量：792 次

发布时间：2023-02-24

本文共 1646 字，大约阅读时间需要 5 分钟。

Oracle.DataAccess.dll?OracleHelper??????

???????????Oracle?????????Oracle.DataAccess.Client???????????????????????????

????Oracle.DataAccess.dll

?????????????????Oracle.DataAccess.dll????????????????

??DLL???????????????E:\app\Orcl\product\11.2.0\dbhome_1\ODP.NET\bin\2.x\Oracle.DataAccess.dll?

?????????web.config??????????????????OracleConnString????????????

????OracleHelper?

OracleHelper????????????????Oracle??????????????????

public static OracleConnection GetConn(){    return new OracleConnection(ConfigurationManager.ConnectionStrings["OracleConnString"].ToString());}

???????????????????????OracleConnection???

public static DataTable QueryCommand(string querySQL, OracleParameter[] oraParams){    DataTable dt = new DataTable();    OracleConnection conn = OracleHelper.GetConn();    OracleCommand cmd = new OracleCommand(querySQL, conn);    if (oraParams != null && oraParams.Length > 0)    {        foreach (OracleParameter oraParam in oraParams)        {            cmd.Parameters.Add(oraParam);        }    }    OracleDataAdapter adapter = new OracleDataAdapter(cmd);    adapter.Fill(dt);    conn.Close();    return dt;}

???????SQL??????????DataTable?????????????????