public static SqlParameter[] GetSpParameterSet(string connectionString, string spName) { return(SqlHelperParameterCache.GetSpParameterSet(connectionString, spName, false)); }
public static SqlParameter[] GetSpParameterSet(string connectionString, string spName, bool includeReturnValueParameter) { string hashKey = connectionString + ":" + spName + (includeReturnValueParameter ? ":include ReturnValue Parameter" : ""); SqlParameter[] cachedParameters = (SqlParameter[])SqlHelperParameterCache.paramCache[hashKey]; if (cachedParameters == null) { cachedParameters = (SqlParameter[])(SqlHelperParameterCache.paramCache[hashKey] = SqlHelperParameterCache.DiscoverSpParameterSet(connectionString, spName, includeReturnValueParameter)); } return(SqlHelperParameterCache.CloneParameters(cachedParameters)); }