public static SqlExpression UpdateNode(UpdateStatementHeadToken head, WhereExpressionNode where = null) { return(SqlExpression.NewUpdate( new UpdateExpression( head, where.ToOption()))); }
public static AST.ICommonTableDefinition TableDef <TType>( TableIdentifier <TType> tdef, SelectValuesExpressionNode select, FromExpressionNode from, WhereExpressionNode where = null, GroupByExpressionNode groupBy = null, OrderByExpressionNode orderBy = null) { return (new AST.CommonTableDefinition <TType>( PlainSelectExpression.NewPlain( new SelectExpressionToken(select, from, where.ToOption(), groupBy.ToOption(), orderBy.ToOption())), tdef)); }
public static SelectExpressionToken PlainSelect( SelectValuesExpressionNode select, FromExpressionNode from, WhereExpressionNode where = null, GroupByExpressionNode groupBy = null, OrderByExpressionNode orderBy = null) { return (new SelectExpressionToken( select, from, where.ToOption(), groupBy.ToOption(), orderBy.ToOption())); }
public static SelectExpressionToken PlainSelect( SelectValuesExpressionNode select, FromExpressionNode from, WhereExpressionNode where = null, GroupByExpressionNode groupBy = null, OrderByExpressionNode orderBy = null, LimitOffsetNode limitOffset = null) { return (new SelectExpressionToken( select, from, where.ToOption(), groupBy.ToOption(), orderBy.ToOption(), limitOffset ?? new LimitOffsetNode(FSharpOption <int> .None, FSharpOption <int> .None))); }
public static SqlExpression DeleteNode(FromExpressionNode from, WhereExpressionNode where = null) { return(SqlExpression.NewDelete( new DeleteExpression(from, where.ToOption()))); }