public static SqlParameter AddWithNullableValue(this SqlParameterCollection collection, string parameterName, object value) { if (value == null || (value is string && ((string)value == string.Empty)) || (value is int && ((int)value == 0))) return collection.AddWithValue(parameterName, DBNull.Value); else return collection.AddWithValue(parameterName, value); }
public static SqlParameterCollection AddSlidingExpirationInSeconds( this SqlParameterCollection parameters, TimeSpan? value) { if (value.HasValue) { return parameters.AddWithValue( Columns.Names.SlidingExpirationInSeconds, SqlDbType.BigInt, value.Value.TotalSeconds); } else { return parameters.AddWithValue(Columns.Names.SlidingExpirationInSeconds, SqlDbType.BigInt, DBNull.Value); } }
public static SqlParameterCollection AddAbsoluteExpiration( this SqlParameterCollection parameters, DateTimeOffset? utcTime) { if (utcTime.HasValue) { return parameters.AddWithValue( Columns.Names.AbsoluteExpiration, SqlDbType.DateTimeOffset, utcTime.Value); } else { return parameters.AddWithValue( Columns.Names.AbsoluteExpiration, SqlDbType.DateTimeOffset, DBNull.Value); } }
/// <summary> /// A SqlParameterCollection extension method that adds a range with value to 'values'. /// </summary> /// <param name="this">The @this to act on.</param> /// <param name="values">The values.</param> public static void AddRangeWithValue(this SqlCeParameterCollection @this, Dictionary<string, object> values) { foreach (var keyValuePair in values) { @this.AddWithValue(keyValuePair.Key, keyValuePair.Value); } }
public static SqlParameterCollection AddCacheItemValue(this SqlParameterCollection parameters, byte[] value) { if (value != null && value.Length < DefaultValueColumnWidth) { return parameters.AddWithValue( Columns.Names.CacheItemValue, SqlDbType.VarBinary, DefaultValueColumnWidth, value); } else { // do not mention the size return parameters.AddWithValue(Columns.Names.CacheItemValue, SqlDbType.VarBinary, value); } }
public static void AddIdParameter( this SqliteParameterCollection source, ITasqueCore item) { if (source == null) throw new NullReferenceException ("source"); if (item == null) throw new ArgumentNullException ("item"); source.AddWithValue ("@id", int.Parse (item.Id)); }
public static SqlParameterCollection AddCacheItemId(this SqlParameterCollection parameters, string value) { return parameters.AddWithValue(Columns.Names.CacheItemId, SqlDbType.NVarChar, 900, value); }
public static SqlParameter AddWithNullableValue(this SqlParameterCollection collection, string parameterName, object value) { return collection.AddWithValue(parameterName, value ?? DBNull.Value); }
public static SqlParameterCollection AddExpiresAtTimeMono( this SqlParameterCollection parameters, DateTimeOffset utcTime) { return parameters.AddWithValue(Columns.Names.ExpiresAtTime, SqlDbType.DateTime, utcTime.UtcDateTime); }
/// <summary> /// Fügt am Ende der SqlParameterCollection einen Wert hinzu. /// </summary> /// <param name = "parameters"></param> /// <param name = "parameterName">Der Name des Parameters</param> /// <param name = "value"> /// Der hinzuzufügende Wert. Wenn der Wert null ist, dann wird DBNull.Value hinzugefügt /// </param> public static void AddWithNullableValue(this SqlParameterCollection parameters, string parameterName, object value) { parameters.AddWithValue(parameterName, value ?? DBNull.Value); }
public static void AddGuid(this SQLiteParameterCollection parmeters, string parameterName, Guid? guid) { parmeters.AddWithValue(parameterName, guid?.ToString("D")); }