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