/// <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);
}
/// <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);
}
