public static T AddTimestampInParam <T>(this DbHelper <T> helper, string parameterName, Byte[] value, bool useDbNullIfNull = false) where T : DbHelper <T>
{
return(helper.AddInParam(parameterName, SqlDbType.Timestamp, value, useDbNullIfNull));
}
public static T AddStructParam <T>(this DbHelper <T> helper, string parameterName, DataTable value, bool useDbNullIfNull = false) where T : DbHelper <T>
{
return(helper.AddInParam(parameterName, SqlDbType.Structured, value, useDbNullIfNull));
}
public static T AddSmallIntInParam <T>(this DbHelper <T> helper, string parameterName, short?value, bool useDbNullIfNull = false) where T : DbHelper <T>
{
return(helper.AddInParam(parameterName, SqlDbType.SmallInt, value, useDbNullIfNull));
}
public static T AddGuidInParam <T>(this DbHelper <T> helper, string parameterName, Guid?value, bool useDbNullIfNull = false) where T : DbHelper <T>
{
return(helper.AddInParam(parameterName, SqlDbType.UniqueIdentifier, value == null ? null : (object)new System.Data.SqlTypes.SqlGuid(value.Value), useDbNullIfNull));
}
public static T AddFloatInParam <T>(this DbHelper <T> helper, string parameterName, double?value, bool useDbNullIfNull = false) where T : DbHelper <T>
{
return(helper.AddInParam(parameterName, SqlDbType.Float, value, useDbNullIfNull));
}
public static T AddMoneyInParam <T>(this DbHelper <T> helper, string parameterName, decimal?value, bool useDbNullIfNull = false) where T : DbHelper <T>
{
return(helper.AddInParam(parameterName, SqlDbType.Money, value, useDbNullIfNull));
}
public static T AddDateTimeOffsetInParam <T>(this DbHelper <T> helper, string parameterName, DateTimeOffset?value, bool useDbNullIfNull = false) where T : DbHelper <T>
{
return(helper.AddInParam(parameterName, SqlDbType.DateTimeOffset, value, useDbNullIfNull));
}
public static T AddXmlInParam <T>(this DbHelper <T> helper, string parameterName, XElement value, bool useDbNullIfNull = false) where T : DbHelper <T>
{
return(helper.AddInParam(parameterName, SqlDbType.Xml, value == null ? null : value.ToString(), useDbNullIfNull));
}
public static T AddNtextInParam <T>(this DbHelper <T> helper, string parameterName, string value, bool useDbNullIfNull = false) where T : DbHelper <T>
{
return(helper.AddInParam(parameterName, SqlDbType.NText, value == null ? 0 : value.Length, (object)value, useDbNullIfNull));
}
