public static SqlParameter[] GetCachedParameterSet(string connectionString, string commandText)
{
if (connectionString == null || connectionString.Length == 0)
{
throw new ArgumentNullException("connectionString");
}
if (commandText == null || commandText.Length == 0)
{
throw new ArgumentNullException("commandText");
}
string str = string.Concat(connectionString, ":", commandText);
SqlParameter[] item = SqlHelperParameterCache.paramCache[str] as SqlParameter[];
if (item == null)
{
return(null);
}
return(SqlHelperParameterCache.CloneParameters(item));
}
private static SqlParameter[] GetSpParameterSetInternal(SqlConnection connection, string spName, bool includeReturnValueParameter)
{
if (connection == null)
{
throw new ArgumentNullException("connection");
}
if (spName == null || spName.Length == 0)
{
throw new ArgumentNullException("spName");
}
string str = string.Concat(connection.ConnectionString, ":", spName, (includeReturnValueParameter ? ":include ReturnValue Parameter" : ""));
SqlParameter[] item = SqlHelperParameterCache.paramCache[str] as SqlParameter[];
if (item == null)
{
SqlParameter[] sqlParameterArray = SqlHelperParameterCache.DiscoverSpParameterSet(connection, spName, includeReturnValueParameter);
SqlHelperParameterCache.paramCache[str] = sqlParameterArray;
item = sqlParameterArray;
}
return(SqlHelperParameterCache.CloneParameters(item));
}