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