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