public static LogicalBinaryExpression Between(SqlExpression left, SqlExpression value1, SqlExpression value2)
{
return(LogicalBinaryExpression.Expression(ExpressionType.Between, left, new CollectionExpression()
{
value1, value2
}));
}
public Queryable <T> GroupBy(Expression <Func <T, object> > field, LogicalBinaryExpression having)
{
Groups.Add(SqlExpression.Field(field));
if (having != null)
{
_having = SqlExpression.AndAlso(_having, having);
}
return(this);
}
public static LogicalBinaryExpression Like(SqlExpression left, SqlExpression right, bool startWith, bool endWith)
{
if (startWith)
{
right = SqlExpression.Add(right, WildcardsExpression.Instance);
}
if (endWith)
{
right = SqlExpression.Add(WildcardsExpression.Instance, right);
}
return(LogicalBinaryExpression.Expression(ExpressionType.Like, left, right));
}
public Queryable <T> GroupBy(SqlExpression field, LogicalBinaryExpression having)
{
if (field == null)
{
throw new ArgumentNullException("field");
}
Groups.Add(field);
if (having != null)
{
_having = SqlExpression.AndAlso(_having, having);
}
return(this);
}
public static LogicalBinaryExpression NotIn(SqlExpression left, SqlExpression right)
{
if (left is DbNullExpression)
{
return(IsNotNull(right));
}
if (right is DbNullExpression)
{
return(IsNotNull(left));
}
return(LogicalBinaryExpression.Expression(ExpressionType.NotIn, left, right));
}
public Queryable <T> Where(LogicalBinaryExpression logical)
{
if (logical == null)
{
throw new ArgumentNullException("condition");
}
if (_where == null)
{
_where = logical;
}
else
{
_where = SqlExpression.AndAlso(_where, logical);
}
return(this);
}
public Queryable <T> Where(Expression <Func <T, bool> > logical)
{
return(Where(LogicalBinaryExpression.Expression(logical)));
}
public static LogicalBinaryExpression In(SqlExpression left, CollectionExpression right)
{
return(LogicalBinaryExpression.Expression(ExpressionType.In, left, right));
}
public static LogicalBinaryExpression LessThanOrEqual(SqlExpression left, SqlExpression right)
{
return(LogicalBinaryExpression.Expression(ExpressionType.LessThanOrEqual, left, right));
}
public static LogicalBinaryExpression GreaterThan(SqlExpression left, SqlExpression right)
{
return(LogicalBinaryExpression.Expression(ExpressionType.GreaterThan, left, right));
}
public static LogicalBinaryExpression IsNotNull(SqlExpression left)
{
return(LogicalBinaryExpression.Expression(ExpressionType.IsNot, left, DbNullExpression.Instance));
}
public static LogicalBinaryExpression OrElse(SqlExpression left, SqlExpression right)
{
return(LogicalBinaryExpression.Expression(ExpressionType.OrElse, left, right));
}
public static LogicalBinaryExpression AndAlso(SqlExpression left, SqlExpression right)
{
return(LogicalBinaryExpression.Expression(ExpressionType.AndAlso, left, right));
}
