C# (CSharp) DbExpressionFactory.In Examples

Example #1

File: DbExpressionFactoryTests.cs Project: zymITsky/DbExpressions

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

Example #2

File: DbExpressionFactoryTests.cs Project: zymITsky/DbExpressions

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

Example #3

File: DbExpressionFactoryTests.cs Project: zymITsky/DbExpressions

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

Example #4

File: DbExpressionFactoryTests.cs Project: seesharper/DbExpressions

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

Example #5

File: DbExpressionFactoryTests.cs Project: seesharper/DbExpressions

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

Example #6

File: DbExpressionFactoryTests.cs Project: seesharper/DbExpressions

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