public void ShouldCreateInExpressionUsingValueRange() { var factory = new DbExpressionFactory(); var expression = factory.In(factory.Column("SomeColumn"), new object[] { 1, 2 }); Assert.IsNotNull(expression.Expression); Assert.IsTrue(expression.ExpressionType == DbExpressionType.In); }
public void ShouldCreateNotExpression() { var factory = new DbExpressionFactory(); var expression = factory.Not(factory.In(factory.Column("SomeColumn"), new object[] { 1, 2 })); Assert.IsNotNull(expression.Operand); Assert.IsTrue(expression.ExpressionType == DbExpressionType.Unary); Assert.IsTrue(expression.UnaryExpressionType == DbUnaryExpressionType.Not); }
public void ShouldCreateInExpressionUsingSubSelect() { var factory = new DbExpressionFactory(); var expression = factory.In(factory.Column("SomeColumn"), factory.Select(f => f.Column("SomeOtherColumn")).From(e => e.Table("SomeTable"))); Assert.IsNotNull(expression.Expression); Assert.IsTrue(expression.ExpressionType == DbExpressionType.In); }