public void AndAlso(SqlValueExpression <TEntity, bool> conditionExpression) { _expression = _expression.AndAlso( conditionExpression.QueryExpression ); AddJoins(conditionExpression.Joins); }
public SelectQueryBuilder AddElement(object value, string alias) { elements.Add(CreateSelectElement(SqlValueExpression.From(value), alias)); return(this); }
public void OrElse(SqlValueExpression <TEntity, bool> conditionExpression) { _expression = _expression.OrElse( conditionExpression.QueryExpression ); AddJoins(conditionExpression.Joins); }
public override int GetHashCode() { int hash = 13; hash = (hash * 7) + Title.GetHashCode(); hash = (hash * 7) + SqlValueExpression.GetHashCode(); return(hash); }
private SelectElement CreateSelectElement(SqlValueExpression value, string alias) { switch (value) { case FieldReference field: return(new SelectElementExpression(field, alias ?? field.FieldName)); default: return(new SelectElementExpression(value, alias)); } }
protected virtual void ParseValueExpression(SqlValueExpression expression) { switch (expression) { case FieldReference field: ParseField(field); return; case SqlConstantExpression constant: ParseParameter(constant); return; case SqlArithmeticalExpression arithmetical: ParseArithmeticalExpression(arithmetical); return; default: UnknowExpression(expression); return; } }
public SqlUpdateBuilder <TEntity> OrWhere(SqlValueExpression <TEntity, bool> conditionExpression) { _whereBuilder.OrElse(conditionExpression); return(this); }
public void OrderByDescending <TValue>(SqlValueExpression <TEntity, TValue> expression) { _expressions.Add(new SqlValueExpression <TEntity, TValue>( QueryExpression.OrderByDescending(expression.QueryExpression), expression.Joins )); }
public SqlUpdateBuilder <TEntity> AndWhere(SqlValueExpression <TEntity, bool> conditionExpression) { _whereBuilder.AndAlso(conditionExpression); return(this); }
public TSelf Offset <TValue>(SqlValueExpression <TEntity, TValue> expression) { QueryBuilder.Offset(expression); return(_self); }
public void Limit <TValue>(SqlValueExpression <TEntity, TValue> expression) { _limit = expression; }
public void GroupBy <TValue>(SqlValueExpression <TEntity, TValue> expression) { _expressions.Add(new SqlValueExpression <TEntity, TValue>( QueryExpression.GroupBy(expression.QueryExpression), expression.Joins)); }
public TSelf OrHaving(SqlValueExpression <TEntity, bool> conditionExpression) { QueryBuilder.OrHaving(conditionExpression); return(_self); }
public SqlUpdateOperation <TEntity> AndWhere(SqlValueExpression <TEntity, bool> conditionExpression) { _queryBuilder.AndWhere(conditionExpression); return(this); }
IWhereQueryBuilder <TEntity> IWhereQueryBuilder <TEntity> .OrWhere(SqlValueExpression <TEntity, bool> conditionExpression) => OrWhere(conditionExpression);
IOrderByQueryBuilder <TEntity> IOrderByQueryBuilder <TEntity> .OrderBy <TValue>(SqlValueExpression <TEntity, TValue> expression) => OrderBy(expression);
IOrderByQueryBuilder <TEntity> IOrderByQueryBuilder <TEntity> .OrderByDescending <TValue>(SqlValueExpression <TEntity, TValue> expression) => OrderByDescending(expression);
IRangeQueryBuilder <TEntity> IRangeQueryBuilder <TEntity> .Offset <TValue>(SqlValueExpression <TEntity, TValue> expression) => Offset(expression);
IRangeQueryBuilder <TEntity> IRangeQueryBuilder <TEntity> .Limit <TValue>(SqlValueExpression <TEntity, TValue> expression) => Limit(expression);
IGroupByQueryBuilder <TEntity> IGroupByQueryBuilder <TEntity> .GroupBy <TValue>(SqlValueExpression <TEntity, TValue> expression) => GroupBy(expression);
public void Offset <TValue>(SqlValueExpression <TEntity, TValue> expression) { _offset = expression; }
public SqlSelectBuilder <TEntity> OrderByDescending <TValue>(SqlValueExpression <TEntity, TValue> expression) { _orderByBuilder.OrderByDescending(expression); return(this); }
public SqlSelectBuilder <TEntity> Offset <TValue>(SqlValueExpression <TEntity, TValue> expression) { _rangeBuilder.Offset(expression); return(this); }
public SelectElementExpression(SqlValueExpression expression, string alias) { Alias = alias ?? throw new ArgumentNullException(nameof(alias)); Expression = expression ?? throw new ArgumentNullException(nameof(expression)); }
IHavingQueryBuilder <TEntity> IHavingQueryBuilder <TEntity> .OrHaving(SqlValueExpression <TEntity, bool> conditionExpression) => OrHaving(conditionExpression);
public TSelf OrderByDescending <TValue>(SqlValueExpression <TEntity, TValue> expression) { QueryBuilder.OrderByDescending(expression); return(_self); }
public SqlDeleteOperation <TEntity> OrWhere(SqlValueExpression <TEntity, bool> conditionExpression) { _queryBuilder.OrWhere(conditionExpression); return(this); }
public TSelf AndWhere(SqlValueExpression <TEntity, bool> conditionExpression) { QueryBuilder.AndWhere(conditionExpression); return(_self); }
public TSelf GroupBy <TValue>(SqlValueExpression <TEntity, TValue> expression) { QueryBuilder.GroupBy(expression); return(_self); }
public SqlSelectBuilder <TEntity> GroupBy <TValue>(SqlValueExpression <TEntity, TValue> expression) { _groupByBuilder.GroupBy(expression); return(this); }