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);
}
