ScalarSqlExpression <X> Quantify <X>( ScalarSqlExpression <X> expression, string quantifier ) { Field(expression); return(Statement.Quantify <X>(quantifier)); }
FieldlessSelectBuilder OrderByImpl( ScalarSqlExpression expression, OrderDirection direction ) { Statement.OrderKeys.Add(new OrderKey(expression, direction)); return(this); }
public static ScalarSqlExpression <string> Concat( this ScalarSqlExpression <string> lhs, params ScalarSqlExpression <string>[] rhs ) { var part = Invoke("concat", new[] { lhs }.Concat(rhs)); return(new ConcreteScalarSqlExpression <string>(lhs.SqlBuilder, part)); }
public static SqlCondition IsNull <X>( this ScalarSqlExpression <X> lhs ) { return (new AtomicSqlCondition( lhs.SqlBuilder, lhs.Concat(SqlPart.FromString("is null")).Tokens )); }
public static SqlCondition Equal <X>( this ScalarSqlExpression <X> lhs, ScalarSqlExpression <X> rhs ) { return (new AtomicSqlCondition( lhs.SqlBuilder, lhs.Concat(SqlPart.FromString("=")).Concat(rhs).Tokens )); }
internal AliasedScalarSqlExpression(ScalarSqlExpression <TValue> expression, string alias) : base(expression.SqlBuilder) { Expression = expression; Alias = alias; }
public static ScalarSqlExpression <X> Unbox <X>(this ScalarSqlExpression expression) { return(new ConcreteScalarSqlExpression <X>(expression.SqlBuilder, expression.Tokens)); }
public OrderKey(ScalarSqlExpression expression, OrderDirection direction) { Expression = expression; Direction = direction; }
public ScalarSqlExpression <X> ToScalar <X>(ScalarSqlExpression <X> expression) { Field(expression); return(Statement.ToScalar <X>()); }
public SelectBuilder Field(ScalarSqlExpression expression) { Statement.Fields.Add(expression); return(new SelectBuilder(Statement)); }
public FieldlessSelectBuilder OrderByDescending(ScalarSqlExpression column) { return(OrderByImpl(column, OrderDirection.Descending)); }
public FieldlessSelectBuilder GroupBy(ScalarSqlExpression expression) { Statement.GroupKeys.Add(expression); return(this); }
public ScalarSqlExpression <X> All <X>(ScalarSqlExpression <X> expression) { return(Quantify(expression, "all")); }
public ScalarSqlExpression <X> Any <X>(ScalarSqlExpression <X> expression) { return(Quantify(expression, "any")); }