C# 使用oracle绑定变量后，查询效率变慢如何解决？满意可加分

Question

oralce  绑定变量  C#

Answer 1

代码如下：public System.Data.DataSet Query(string SQLString, List<DBParameter> dbParam)
        {
            using (OracleConnection connection = new OracleConnection(connectionString))
            {
                DataSet ds = new DataSet();
                try
                {
                    connection.Open();                    OracleCommand cmd = GetCommand(SQLString, connection, dbParam);                    OracleDataAdapter command = new OracleDataAdapter(cmd);
                    command.Fill(ds, "ds");
                }
                catch (System.Data.OracleClient.OracleException ex)
                {
                    throw new Exception(ex.Message);
                }
                connection.Close();
                connection.Dispose();
                return ds;
            }
        }public OracleCommand GetCommand(string SQLString, OracleConnection conn, List<DBParameter> dbParamers)
        {
            SQLString = DBBindFunction.GetFormatSQL(SQLString, "ORACLE");
            OracleCommand oraCommand = new OracleCommand(SQLString, conn);            if (dbParamers.Count > 0)
            {
                foreach (DBParameter dbParam in dbParamers)
                {
                    OracleParameter oraParam = new OracleParameter();
                    oraParam.DbType = dbParam.ParameterType;
                    oraParam.ParameterName = dbParam.ParameterName;
                    oraParam.Value = dbParam.ParameterValue;
                    oraCommand.Parameters.Add(oraParam);
                }
            }
            return oraCommand;
        }