public void ShouldCreateOrUsingOperatorOverloading() { var factory = new DbExpressionFactory(); var expression = (DbBinaryExpression)(factory.Column("SomeColumn") | factory.Column("SomeOtherColumn")); Assert.AreEqual(DbBinaryExpressionType.Or, expression.BinaryExpressionType); }
public void ShouldCreateBatchExpression() { var factory = new DbExpressionFactory(); var expression = factory.Batch(new DbExpression[] { factory.Column("SomeColumn"), factory.Column("SomeOtherColumn") }); Assert.IsTrue(expression.Count() == 2); Assert.IsTrue(expression.ExpressionType == DbExpressionType.Batch); }
public void ShouldCreateRightOuterExpression() { var factory = new DbExpressionFactory(); var expression = factory.RightOuterJoin(factory.Table("SomeTable"), factory.Column("SomeColumn") == factory.Column("SomeOtherColumn")); Assert.IsNotNull(expression.Condition); Assert.IsNotNull(expression.Target); Assert.IsTrue(expression.ExpressionType == DbExpressionType.Join); Assert.IsTrue(expression.JoinExpressionType == DbJoinExpressionType.RightOuterJoin); }
public void ShouldCreateNotEqualOperatorOverloading() { var factory = new DbExpressionFactory(); var expression = (DbBinaryExpression)(factory.Column("SomeColumn") != 1); Assert.AreEqual(DbBinaryExpressionType.NotEqual, expression.BinaryExpressionType); }
public void ShouldCreateGreaterThanUsingOperatorOverloading() { var factory = new DbExpressionFactory(); var expression = (DbBinaryExpression)(factory.Column("SomeColumn") > 1); Assert.AreEqual(DbBinaryExpressionType.GreaterThan, expression.BinaryExpressionType); }
public void ShouldCreateLengthExpression() { var factory = new DbExpressionFactory(); var stringFunctionExpression = factory.Length(factory.Column("SomeStringColumn")); ValidateStringFunctionExpression(stringFunctionExpression, DbStringFunctionExpressionType.Length); }
public void ShouldCreateMinExpression() { var factory = new DbExpressionFactory(); var aggregateExpression = factory.Min(factory.Column("SomeColumn")); ValidateAggregateExpression(aggregateExpression, DbAggregateFunctionExpressionType.Min); }
public void ShouldCreateReverseExpression() { var factory = new DbExpressionFactory(); var stringFunctionExpression = factory.Reverse(factory.Column("SomeStringColumn")); ValidateStringFunctionExpression(stringFunctionExpression, DbStringFunctionExpressionType.Reverse); }
public void ShouldCreateReplaceExpression() { var factory = new DbExpressionFactory(); var stringFunctionExpression = factory.Replace(factory.Column("SomeStringColumn"), factory.Constant("OldValue"), factory.Constant("NewValue")); ValidateStringFunctionExpression(stringFunctionExpression, DbStringFunctionExpressionType.Replace); }
public void ShouldCreateSubStringExpression() { var factory = new DbExpressionFactory(); var stringFunctionExpression = factory.SubString(factory.Column("SomeStringColumn"), factory.Constant(1), factory.Constant(2)); ValidateStringFunctionExpression(stringFunctionExpression, DbStringFunctionExpressionType.SubString); }
public void ShouldCreateSoundExExpression() { var factory = new DbExpressionFactory(); var stringFunctionExpression = factory.SoundEx(factory.Column("SomeStringColumn")); ValidateStringFunctionExpression(stringFunctionExpression, DbStringFunctionExpressionType.SoundEx); }
public void ShouldCreateTrimStartEndExpression() { var factory = new DbExpressionFactory(); var stringFunctionExpression = factory.TrimEnd(factory.Column("SomeStringColumn")); ValidateStringFunctionExpression(stringFunctionExpression, DbStringFunctionExpressionType.TrimEnd); }
public void ShouldCreateToUpperExpression() { var factory = new DbExpressionFactory(); var stringFunctionExpression = factory.ToUpper(factory.Column("SomeStringColumn")); ValidateStringFunctionExpression(stringFunctionExpression, DbStringFunctionExpressionType.ToUpper); }
public void ShouldCreateAddMinutesExpression() { var factory = new DbExpressionFactory(); DbDateTimeFunctionExpression dateTimeFunctionExpression; dateTimeFunctionExpression = factory.AddMinutes(factory.Column("SomeDateTimeColumn"), factory.Constant(2)); ValidateDateTimeFunctionExpression(dateTimeFunctionExpression, DbDateTimeFunctionExpressionType.AddMinutes); }
public void ShoudCreateConstantExpressionWhenCheckingForNotNull() { var factory = new DbExpressionFactory(); var expression = (DbBinaryExpression)(factory.Column("SomeColumn") != null); Assert.IsNotNull(expression.RightExpression); }
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 ShouldCreateAddMillisecondsExpression() { var factory = new DbExpressionFactory(); DbDateTimeFunctionExpression dateTimeFunctionExpression; dateTimeFunctionExpression = factory.AddMilliseconds(factory.Column("SomeDateTimeColumn"), factory.Constant(2)); ValidateDateTimeFunctionExpression(dateTimeFunctionExpression, DbDateTimeFunctionExpressionType.AddMilliseconds); }
public void ShouldCreateMillisecondExpression() { var factory = new DbExpressionFactory(); DbDateTimeFunctionExpression dateTimeFunctionExpression; dateTimeFunctionExpression = factory.Millisecond(factory.Column("SomeDateTimeColumn")); ValidateDateTimeFunctionExpression(dateTimeFunctionExpression, DbDateTimeFunctionExpressionType.MilliSecond); }
public void ShouldCreateDayOfWeekExpression() { var factory = new DbExpressionFactory(); DbDateTimeFunctionExpression dateTimeFunctionExpression; dateTimeFunctionExpression = factory.DayOfWeek(factory.Column("SomeDateTimeColumn")); ValidateDateTimeFunctionExpression(dateTimeFunctionExpression, DbDateTimeFunctionExpressionType.DayOfWeek); }
public void ShouldCreatePrefixExpression() { var factory = new DbExpressionFactory(); var expression = factory.Prefix(factory.Column("SomeColumn"), "sc"); Assert.IsNotNull(expression.Target); Assert.IsNotNull(expression.Prefix); Assert.IsTrue(expression.ExpressionType == DbExpressionType.Prefix); }
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); }
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 ShouldCreateOrderByAscendingExpression() { var factory = new DbExpressionFactory(); var expression = factory.OrderByAscending(factory.Column("SomeColumn")); Assert.IsNotNull(expression.Expression); Assert.IsTrue(expression.OrderByExpressionType == DbOrderByExpressionType.Ascending); Assert.IsTrue(expression.ExpressionType == DbExpressionType.OrderBy); }
public void ShouldCreateColumnExpression() { var factory = new DbExpressionFactory(); var expression = factory.Column("SomeColumn"); Assert.IsNotNull(expression); Assert.IsNotNull(expression.ColumnName); Assert.IsTrue(expression.ExpressionType == DbExpressionType.Column); }
public void ShouldCreateConditionalExpression() { var factory = new DbExpressionFactory(); var expression = factory.Conditional(factory.Column("SomeColumn") == factory.Constant("SomeValue"), factory.Constant("ValueWhenTrue"), factory.Constant("ValueWhenFalse")); Assert.IsNotNull(expression.Condition); Assert.IsNotNull(expression.IfFalse); Assert.IsNotNull(expression.IfTrue); Assert.IsTrue(expression.ExpressionType == DbExpressionType.Conditional); }
public void ShouldCreateCastExpression() { var factory = new DbExpressionFactory(); var castExpression = factory.Cast(factory.Column("SomeColumn"), typeof(Int32)); var test = castExpression.ToString(); }
public void ShouldCreateTanExpression() { var factory = new DbExpressionFactory(); DbMathematicalFunctionExpression mathematicalFunctionExpression = factory.Tan(factory.Column("SomeColumn")); ValidateMathematicalFunctionExpression(mathematicalFunctionExpression, DbMathematicalFunctionExpressionType.Tan); }
public void ShouldCreateYearExpression() { var factory = new DbExpressionFactory(); DbDateTimeFunctionExpression dateTimeFunctionExpression; dateTimeFunctionExpression = factory.Year(factory.Column("SomeDateTimeColumn")); ValidateDateTimeFunctionExpression(dateTimeFunctionExpression, DbDateTimeFunctionExpressionType.Year); }
public void ShouldCreateTrimStartExpression() { var factory = new DbExpressionFactory(); var stringFunctionExpression = factory.TrimStart(factory.Column("SomeStringColumn")); ValidateStringFunctionExpression(stringFunctionExpression, DbStringFunctionExpressionType.TrimStart); }
public void ShouldCreateRoundExpression() { var factory = new DbExpressionFactory(); DbMathematicalFunctionExpression mathematicalFunctionExpression = factory.Round(factory.Column("SomeColumn"), factory.Constant(2)); ValidateMathematicalFunctionExpression(mathematicalFunctionExpression, DbMathematicalFunctionExpressionType.Round); }
public void ShouldCreateOrderByDescendingExpression() { var factory = new DbExpressionFactory(); var expression = factory.OrderByDescending(factory.Column("SomeColumn")); Assert.IsNotNull(expression.Expression); Assert.IsTrue(expression.OrderByExpressionType == DbOrderByExpressionType.Descending); Assert.IsTrue(expression.ExpressionType == DbExpressionType.OrderBy); }
public void ShouldCreateLessThanUsingOperatorOverloading() { var factory = new DbExpressionFactory(); var expression = (DbBinaryExpression)(factory.Column("SomeColumn") < 1); Assert.AreEqual(DbBinaryExpressionType.LessThan, expression.BinaryExpressionType); }
public void ShouldCreateListExpression() { var factory = new DbExpressionFactory(); var expression = factory.List(new DbExpression[] { factory.Column("SomeColumn"), factory.Column("SomeOtherColumn") }); Assert.IsTrue(expression.Count() == 2); Assert.IsTrue(expression.ExpressionType == DbExpressionType.List); }
public void ShouldCreateSumExpression() { var factory = new DbExpressionFactory(); var aggregateExpression = factory.Sum(factory.Column("SomeColumn")); ValidateAggregateExpression(aggregateExpression, DbAggregateFunctionExpressionType.Sum); }
public void ShoudCreateConstantExpressionWhenCheckingForNull() { var factory = new DbExpressionFactory(); var expression = (DbBinaryExpression)(factory.Column("SomeColumn") == null); Assert.IsNotNull(expression.RightExpression); }