public static SqlExpression InsertNode(InsertStatementHeadToken head, params InsertValueToken[] values)
{
return(SqlExpression.NewInsert(
new InsertExpression(
head,
ListModule.OfArray(values))));
}
public static SqlExpression UpdateNode(UpdateStatementHeadToken head, WhereExpressionNode where = null)
{
return(SqlExpression.NewUpdate(
new UpdateExpression(
head,
where.ToOption())));
}
public static SqlExpression SelectNode(
CommonTableExpression with,
SelectExpressionToken select)
{
return(SqlExpression.NewSelect(
SelectExpression.NewComplex(
new Tuple <CommonTableExpression, PlainSelectExpression>(with, PlainSelectExpression.NewPlain(select)))));
}
public static SqlExpression SelectNode(
SelectValuesExpressionNode select,
FromExpressionNode from,
WhereExpressionNode where = null,
GroupByExpressionNode groupBy = null,
OrderByExpressionNode orderBy = null)
{
return(SqlExpression.NewSelect(
SelectExpression.NewPlain(
PlainSelectExpression.NewPlain(
PlainSelect(select, from, where, groupBy, orderBy)))));
}
public static SqlExpression SelectNode(
CommonTableExpression with,
SelectValuesExpressionNode select,
FromExpressionNode from,
WhereExpressionNode where = null,
GroupByExpressionNode groupBy = null,
OrderByExpressionNode orderBy = null)
{
return(SqlExpression.NewSelect(
SelectExpression.NewComplex(
new Tuple <CommonTableExpression, PlainSelectExpression>(
with,
PlainSelectExpression.NewPlain(PlainSelect(select, from, where, groupBy, orderBy))))));
}
public static SqlExpression DeleteNode(FromExpressionNode from, WhereExpressionNode where = null)
{
return(SqlExpression.NewDelete(
new DeleteExpression(from, where.ToOption())));
}
