public static AST.ICommonTableDefinition TableDef <TType>(
SelectValuesExpressionNode select,
FromExpressionNode from,
WhereExpressionNode where = null,
GroupByExpressionNode groupBy = null,
OrderByExpressionNode orderBy = null)
{
return(TableDef(new TableIdentifier <TType>(), select, from, where, groupBy, orderBy));
}
public static AST.ICommonTableDefinition TableDef <TType>(
TableReferenceCreator <TType> c,
SelectValuesExpressionNode select,
FromExpressionNode from,
WhereExpressionNode where = null,
GroupByExpressionNode groupBy = null,
OrderByExpressionNode orderBy = null)
{
return(TableDef(c.ToTableReference(), select, from, where, groupBy, orderBy));
}
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 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())));
}
