Beispiel #1
0
        //
        // DBExecQuery factory methods
        //

        #region public static DBExecQuery Exec(string name) + 1 overload

        /// <summary>
        /// Begins a new 'EXEC [procedure name]' statement
        /// </summary>
        /// <param name="name">The name of the procedure</param>
        /// <returns>A new DBExecQuery to support statement chaining</returns>
        public static DBExecQuery Exec(string name)
        {
            DBExecQuery exec = new DBExecQuery();

            exec.SprocName = name;
            return(exec);
        }
Beispiel #2
0
        public static DBExecQuery Exec(string catalog, string owner, string name)
        {
            DBExecQuery exec = new DBExecQuery();

            exec.SprocName = name;
            exec.Owner     = owner;
            exec.Catalog   = catalog;
            return(exec);
        }
Beispiel #3
0
        /// <summary>
        /// Appends all the parameters to this exec statement
        /// </summary>
        /// <param name="all"></param>
        /// <returns></returns>
        public DBExecQuery WithParams(params DBParam[] all)
        {
            DBExecQuery exec = this;

            foreach (DBParam p in all)
            {
                exec = exec.WithParam(p);
            }
            return(exec);
        }