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