public static XmlReader ExecuteXmlReader(OracleTransaction transaction, string spName, params object[] parameterValues) { if (parameterValues != null && parameterValues.Length > 0) { OracleParameter[] commandParameters = OracleDataAccessParameterCache.GetSpParameterSet(transaction.Connection.ConnectionString, spName); OracleDataAccess.AssignParameterValues(commandParameters, parameterValues); return(OracleDataAccess.ExecuteXmlReader(transaction, CommandType.StoredProcedure, spName, commandParameters)); } return(OracleDataAccess.ExecuteXmlReader(transaction, CommandType.StoredProcedure, spName)); }
public static object ExecuteScalar(string connectionString, string spName, params object[] parameterValues) { if (parameterValues != null && parameterValues.Length > 0) { OracleParameter[] commandParameters = OracleDataAccessParameterCache.GetSpParameterSet(connectionString, spName); OracleDataAccess.AssignParameterValues(commandParameters, parameterValues); return(OracleDataAccess.ExecuteScalar(connectionString, CommandType.StoredProcedure, spName, commandParameters)); } return(OracleDataAccess.ExecuteScalar(connectionString, CommandType.StoredProcedure, spName)); }
public static OracleParameter[] GetSpParameterSet(string connectionString, string spName, bool includeReturnValueParameter) { string hashKey = connectionString + ":" + spName + (includeReturnValueParameter ? ":include ReturnValue Parameter" : ""); OracleParameter[] cachedParameters = (OracleParameter[])OracleDataAccessParameterCache.paramCache[hashKey]; if (cachedParameters == null) { cachedParameters = (OracleParameter[])(OracleDataAccessParameterCache.paramCache[hashKey] = OracleDataAccessParameterCache.DiscoverSpParameterSet(connectionString, spName, includeReturnValueParameter)); } return(OracleDataAccessParameterCache.CloneParameters(cachedParameters)); }
public static OracleParameter[] GetCachedParameterSet(string connectionString, string commandText) { string hashKey = connectionString + ":" + commandText; OracleParameter[] cachedParameters = (OracleParameter[])OracleDataAccessParameterCache.paramCache[hashKey]; if (cachedParameters == null) { return(null); } return(OracleDataAccessParameterCache.CloneParameters(cachedParameters)); }
public static OracleParameter[] GetSpParameterSet(string connectionString, string spName) { return(OracleDataAccessParameterCache.GetSpParameterSet(connectionString, spName, false)); }