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