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);
}