///<summary>
///</summary>
///<param name="connectionString"></param>
///<param name="commandText"></param>
///<returns></returns>
///<exception cref="ArgumentNullException"></exception>
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 key = connectionString + ":" + commandText;
SqlParameter[] array = SqlHelperParameterCache.paramCache[key] as SqlParameter[];
if (array == null)
{
return(null);
}
return(SqlHelperParameterCache.CloneParameters(array));
}
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 key = connection.ConnectionString + ":" + spName + (includeReturnValueParameter ? ":include ReturnValue Parameter" : "");
SqlParameter[] array = SqlHelperParameterCache.paramCache[key] as SqlParameter[];
if (array == null)
{
SqlParameter[] array2 = SqlHelperParameterCache.DiscoverSpParameterSet(connection, spName, includeReturnValueParameter);
SqlHelperParameterCache.paramCache[key] = array2;
array = array2;
}
return(SqlHelperParameterCache.CloneParameters(array));
}
