public DBExecQuery WithParamValue(string name, System.Data.DbType type, int length, object value)
{
DBParam p = DBParam.ParamWithValue(name, type, length, value);
return(this.WithParam(p));
}
/// <summary>
/// Appends a new parameter to this EXEC statement of the specified type and with the specified value
/// </summary>
/// <param name="type">The DbType of the parameter</param>
/// <param name="paramValue">The value of the parameter</param>
/// <returns>Itself to support statement chaining</returns>
public DBExecQuery WithParamValue(System.Data.DbType type, object paramValue)
{
DBParam p = DBParam.ParamWithValue(type, paramValue);
return(this.WithParam(p));
}
/// <summary>
/// Appends a new parameter to this EXEC statement with the specified name and value.
/// WARNING - specifying null or DBNull will make the DbType undiscoverable at runtime, and may cause execution errors
/// </summary>
/// <param name="name">The name of the parameter</param>
/// <param name="value">The value of the parameter</param>
/// <returns>Itself to support statement chaining</returns>
public DBExecQuery WithParamValue(string name, object value)
{
DBParam p = DBParam.ParamWithValue(name, value);
return(this.WithParam(p));
}
/// <summary>
/// Appends a new parameter to this EXEC statement with the specified value.
/// WARNING - specifying null or DBNull will make the DbType undiscoverable at runtime, and may cause execution errors
/// </summary>
/// <param name="paramValue">The value of the parameter</param>
/// <returns>Itself to support statement chaining</returns>
public DBExecQuery WithParamValue(object paramValue)
{
DBParam p = DBParam.ParamWithValue(paramValue);
return(this.WithParam(p));
}