Beispiel #1
0
        /// <summary>
        /// SQL 'FROM' clause extensions. Add new 'FROM' in clause.
        /// </summary>
        /// <param name="command">The command.</param>
        /// <param name="phrases">The 'FROM' phrases.</param>
        /// <returns>The command.</returns>
        public static APSqlSelectCommand from_add(this APSqlSelectCommand command, IEnumerable <APSqlFromPhrase> phrases)
        {
            if (command.FromClause == null || command.FromClause.Next == null)
            {
                command.FromClause = new APSqlFromClause(phrases);
            }
            else
            {
                APSqlFromPhrase exist = command.FromClause.Last as APSqlFromPhrase;
                exist.SetNext(phrases);
            }

            return(command);
        }
Beispiel #2
0
        /// <summary>
        /// SQL 'FROM' clause extensions. Add new 'FROM' in clause.
        /// </summary>
        /// <param name="command">The command.</param>
        /// <param name="phrases">The 'FROM' phrases.</param>
        /// <returns>The command.</returns>
        public static APSqlDeleteCommand from_add(this APSqlDeleteCommand command, params APSqlFromPhrase[] phrases)
        {
            if (command.FromClause == null || command.FromClause.Next == null)
            {
                command.FromClause = new APSqlFromClause(phrases);
            }
            else
            {
                APSqlFromPhrase exist = command.FromClause.Last as APSqlFromPhrase;
                exist.SetNext(phrases);
            }

            return(command);
        }