Example #1
0
        /// <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));
        }
Example #2
0
        /// <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));
        }
Example #3
0
        /// <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));
        }