public static QuerySpecificationBuilder OrderByDesc(this QuerySpecificationBuilder builder, params String[] columns)
{
return(OrderBy(builder, Ordering.Descending, columns));
}
public static QuerySpecificationBuilder Having(this QuerySpecificationBuilder builder, BooleanExpression expr)
{
builder.HavingBuilder.Reset(expr);
return(builder);
}
public static QuerySpecificationBuilder OrderBy(this QuerySpecificationBuilder builder, Ordering ordering, params String[] columns)
{
builder.OrderByBuilder.AddSortSpecifications(columns.Select(c => builder.SQLVendor.QueryFactory.NewSortSpecification(builder.SQLVendor.QueryFactory.ColumnName(c), ordering)).ToArray());
return(builder);
}
public static QuerySpecificationBuilder Where(this QuerySpecificationBuilder builder, BooleanExpression expr)
{
builder.WhereBuilder.Reset(expr);
return(builder);
}
public static QuerySpecificationBuilder GroupBy(this QuerySpecificationBuilder builder, params String[] columns)
{
builder.GroupByBuilder.AddGroupingElements(columns.Select(c => builder.SQLVendor.QueryFactory.NewGroupingElement(builder.SQLVendor.QueryFactory.ColumnName(c))).ToArray());
return(builder);
}
public static QuerySpecificationBuilder SelectAll(this QuerySpecificationBuilder builder)
{
builder.ColumnsBuilder.SelectAll();
return(builder);
}
public static QuerySpecificationBuilder From(this QuerySpecificationBuilder builder, params TableName[] tables)
{
builder.FromBuilder.AddTableNames(tables);
return(builder);
}
public static QuerySpecificationBuilder Select(this QuerySpecificationBuilder builder, params ValueExpression[] expressions)
{
builder.ColumnsBuilder.AddUnnamedColumns(expressions.Select(e => builder.SQLVendor.QueryFactory.ColumnExpression(e)).ToArray());
return(builder);
}
public static QuerySpecificationBuilder As(this QuerySpecificationBuilder builder, String alias)
{
builder.ColumnsBuilder.SetNameFor(builder.ColumnsBuilder.ColumnCount - 1, alias);
return(builder);
}
public static QuerySpecificationBuilder WithSetQuantifier(this QuerySpecificationBuilder builder, SetQuantifier quantifier)
{
builder.ColumnsBuilder.SetSetQuantifier(quantifier);
return(builder);
}
public static QuerySpecificationBuilder Select(this QuerySpecificationBuilder builder, params String[] colNames)
{
builder.ColumnsBuilder.AddUnnamedColumns(colNames.Select(cn => builder.SQLVendor.QueryFactory.ColumnName(cn)).ToArray());
return(builder);
}
public static QueryExpression CreateSelectStatement(this QuerySpecificationBuilder builder)
{
return(CreateSelectStatement(builder.CreateExpression()));
}
public static QuerySpecificationBuilder Offset(this QuerySpecificationBuilder builder, Int64 skip)
{
return(builder.Offset(builder.SQLVendor.CommonFactory.I64(skip)));
}
public static QuerySpecificationBuilder Limit(this QuerySpecificationBuilder builder, Int64 max)
{
return(builder.Limit(builder.SQLVendor.CommonFactory.I64(max)));
}
