private static QueryExpression CreateComparison(QueryExpression left, SqlComparisonOperator comparisonType, QueryExpression right)
{
switch (comparisonType)
{
case SqlComparisonOperator.AreEqual:
return(QueryExpression.AreEqual(left, right));
case SqlComparisonOperator.AreNotEqual:
return(QueryExpression.AreNotEqual(left, right));
case SqlComparisonOperator.GreaterThan:
return(QueryExpression.GreaterThan(left, right));
case SqlComparisonOperator.GreaterThanOrEqualTo:
return(QueryExpression.GreaterThanOrEqualTo(left, right));
case SqlComparisonOperator.LessThan:
return(QueryExpression.LessThan(left, right));
case SqlComparisonOperator.LessThanOrEqualTo:
return(QueryExpression.LessThanOrEqualTo(left, right));
case SqlComparisonOperator.Like:
return(QueryExpression.Like(left, right));
}
throw new InvalidOperationException();
}
public void OrElse <TValue>(SqlStorageField <TEntity, TValue> field, SqlComparisonOperator comparisonType, TValue value)
{
if (field.RequiresJoin)
{
foreach (var(joinBuilder, _) in field.JoinSpecification.CreateJoin(_dataSchema, field, _tableIdentifier))
{
AddJoin(joinBuilder);
}
}
_expression = _expression.OrElse(
CreateComparison(
QueryExpression.Column(field.ColumnName),
comparisonType,
QueryExpression.Value(value)
));
}
public static DvlSqlComparisonExpression ComparisonExp(DvlSqlConstantExpression leftExp, SqlComparisonOperator op,
DvlSqlConstantExpression rightExp)
=> new DvlSqlComparisonExpression(leftExp, op, rightExp);
IWhereQueryBuilder <TEntity> IWhereQueryBuilder <TEntity> .OrWhere <TValue>(Schema.Sql.SqlStorageField <TEntity, TValue> field, SqlComparisonOperator comparisonType, TValue value) => OrWhere(field, comparisonType, value);
public SqlDeleteOperation <TEntity> OrWhere <TValue>(Schema.Sql.SqlStorageField <TEntity, TValue> field, SqlComparisonOperator comparisonType, TValue value)
{
_queryBuilder.OrWhere(field, comparisonType, value);
return(this);
}
public SqlUpdateBuilder <TEntity> AndWhere <TValue>(SqlStorageField <TEntity, TValue> field, SqlComparisonOperator comparisonType, TValue value)
{
_whereBuilder.AndAlso(field, comparisonType, value);
return(this);
}
public SqlDeleteBuilder <TEntity> OrWhere <TValue>(SqlStorageField <TEntity, TValue> field, SqlComparisonOperator comparisonType, TValue value)
{
_whereBuilder.OrElse(field, comparisonType, value);
return(this);
}
public TSelf AndWhere <TValue>(Schema.Sql.SqlStorageField <TEntity, TValue> field, SqlComparisonOperator comparisonType, TValue value)
{
QueryBuilder.AndWhere(field, comparisonType, value);
return(_self);
}
IHavingQueryBuilder <TEntity> IHavingQueryBuilder <TEntity> .OrHaving <TValue>(Schema.Sql.SqlStorageField <TEntity, TValue> field, SqlComparisonOperator comparisonType, TValue value) => OrHaving(field, comparisonType, value);
public SqlSelectBuilder <TEntity> OrHaving <TValue>(SqlStorageField <TEntity, TValue> field, SqlComparisonOperator comparisonType, TValue value)
{
_havingBuilder.OrElse(field, comparisonType, value);
return(this);
}
public DvlSqlComparisonExpression(DvlSqlConstantExpression leftExpression, SqlComparisonOperator comparisonOperator,
DvlSqlConstantExpression rightExpression) => (this.LeftExpression, this.ComparisonOperator, this.RightExpression) =
