/// <summary>
/// Appends a new parameter to this EXEC statement with the delegate
/// method that will be evaulated at statement generation time ot extract the value
/// </summary>
/// <param name="valueprovider">The delegate method that will return the value</param>
/// <returns>Itself to support statement chaining</returns>
public DBExecQuery WithParamDelegate(ParamValue valueprovider)
{
DBParam p = DBParam.ParamWithDelegate(valueprovider);
return(this.WithParam(p));
}
/// <summary>
/// Appends a new parameter to this EXEC statement with the type and the delegate
/// method that will be evaulated at statement generation time to extract the value
/// </summary>
/// <param name="name">The name of the parameter</param>
/// <param name="type">The DbType of the parameter</param>
/// <param name="valueprovider">The delegate method that will return the value</param>
/// <returns>Itself to support statement chaining</returns>
public DBExecQuery WithParamDelegate(string name, System.Data.DbType type, ParamValue valueprovider)
{
DBParam p = DBParam.ParamWithDelegate(name, type, valueprovider);
return(this.WithParam(p));
}
/// <summary>
/// Specify a value for the correspoding column via a delegate method
/// </summary>
/// <param name="valueProvider">A (anonymous) delegate that returns an object when invoked</param>
/// <returns>Itself so statements can be chained</returns>
public DBInsertQuery Value(ParamValue valueProvider)
{
DBParam p = DBParam.ParamWithDelegate(valueProvider);
return(Value(p));
}