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 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 ShoudCreateConstantExpressionWhenCheckingForNotNull()
{
var factory = new DbExpressionFactory();
var expression = (DbBinaryExpression)(factory.Column("SomeColumn") != null);
Assert.IsNotNull(expression.RightExpression);
}
public void ShouldCreateReverseExpression()
{
var factory = new DbExpressionFactory();
var stringFunctionExpression = factory.Reverse(factory.Column("SomeStringColumn"));
ValidateStringFunctionExpression(stringFunctionExpression, DbStringFunctionExpressionType.Reverse);
}
public void ShouldCreateOrUsingOperatorOverloading()
{
var factory = new DbExpressionFactory();
var expression = (DbBinaryExpression)(factory.Column("SomeColumn") | factory.Column("SomeOtherColumn"));
Assert.AreEqual(DbBinaryExpressionType.Or, expression.BinaryExpressionType);
}
public void ShouldCreateNotEqualOperatorOverloading()
{
var factory = new DbExpressionFactory();
var expression = (DbBinaryExpression)(factory.Column("SomeColumn") != 1);
Assert.AreEqual(DbBinaryExpressionType.NotEqual, expression.BinaryExpressionType);
}
public void ShouldCreateAddExpression()
{
var factory = new DbExpressionFactory();
DbBinaryExpression binaryExpression;
binaryExpression = factory.Add(factory.Constant(1), factory.Constant(2));
ValidateBinaryExpression(binaryExpression, DbBinaryExpressionType.Add);
}
public void ShouldCreateAddMinutesExpression()
{
var factory = new DbExpressionFactory();
DbDateTimeFunctionExpression dateTimeFunctionExpression;
dateTimeFunctionExpression = factory.AddMinutes(factory.Column("SomeDateTimeColumn"), factory.Constant(2));
ValidateDateTimeFunctionExpression(dateTimeFunctionExpression, DbDateTimeFunctionExpressionType.AddMinutes);
}
public void ShouldCreateContantExpression()
{
var factory = new DbExpressionFactory();
var expression = factory.Constant("SomeValue");
Assert.IsNotNull(expression.Value);
Assert.IsTrue(expression.ExpressionType == DbExpressionType.Constant);
}
public void ShouldCreateAliasExpressionUsingAsExtension()
{
var factory = new DbExpressionFactory();
var tableExpression = factory.Table("SomeTable");
var aliasExpression = tableExpression.As("t0");
Assert.AreEqual(DbExpressionType.Alias, aliasExpression.ExpressionType);
}
public void ShouldCreateExistsExpression()
{
var factory = new DbExpressionFactory();
var expression = factory.Exists(factory.Select(e => e.Column("SomeColumn")));
Assert.IsNotNull(expression.SubSelectExpression);
Assert.IsTrue(expression.ExpressionType == DbExpressionType.Exists);
}
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 ShouldCreateAssignmentExpression()
{
var factory = new DbExpressionFactory();
DbBinaryExpression binaryExpression;
binaryExpression = factory.Assign(factory.Constant(1), factory.Constant(2));
ValidateBinaryExpression(binaryExpression, DbBinaryExpressionType.Assignment);
}
public void ShouldCreateLessThanOrEqualExpression()
{
var factory = new DbExpressionFactory();
DbBinaryExpression binaryExpression;
binaryExpression = factory.LessThanOrEqual(factory.Constant(1), factory.Constant(2));
ValidateBinaryExpression(binaryExpression, DbBinaryExpressionType.LessThanOrEqual);
}
public void ShouldCreateOrExpression()
{
var factory = new DbExpressionFactory();
DbBinaryExpression binaryExpression;
binaryExpression = factory.Or(factory.Constant(1), factory.Constant(2));
ValidateBinaryExpression(binaryExpression, DbBinaryExpressionType.Or);
}
public void ShouldCreateSubstractExpression()
{
var factory = new DbExpressionFactory();
DbBinaryExpression binaryExpression;
binaryExpression = factory.Subtract(factory.Constant(1), factory.Constant(2));
ValidateBinaryExpression(binaryExpression, DbBinaryExpressionType.Subtract);
}
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 ShouldCreateNowExpression()
{
var factory = new DbExpressionFactory();
DbDateTimeFunctionExpression dateTimeFunctionExpression;
dateTimeFunctionExpression = factory.Now();
ValidateDateTimeFunctionExpression(dateTimeFunctionExpression, DbDateTimeFunctionExpressionType.Now);
}
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 ShouldCreateEmptyListExpression()
{
var factory = new DbExpressionFactory();
var expression =
factory.List();
Assert.IsTrue(expression.Count() == 0);
Assert.IsTrue(expression.ExpressionType == DbExpressionType.List);
}
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 ShouldCreateAliasedTableExpression()
{
var factory = new DbExpressionFactory();
var expression = factory.Table("SomeTable", "t0");
Assert.IsNotNull(expression);
Assert.IsNotNull(expression.Target);
Assert.IsTrue(expression.ExpressionType == DbExpressionType.Alias);
}
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 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 ShouldCreateTableExpression()
{
var factory = new DbExpressionFactory();
var expression = factory.Table("SomeTable");
Assert.IsNotNull(expression);
Assert.IsNotNull(expression.TableName);
Assert.IsTrue(expression.ExpressionType == DbExpressionType.Table);
}
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 ShouldCreateConcatExpression()
{
var factory = new DbExpressionFactory();
var expression = factory.Concat(factory.Constant("DummyExpression"),
factory.Constant("AnotherDummyExpression"));
Assert.IsNotNull(expression.LeftExpression);
Assert.IsNotNull(expression.RightExpression);
Assert.IsTrue(expression.ExpressionType == DbExpressionType.Concat);
}
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 ShouldCreateSubstractExpression()
{
var factory = new DbExpressionFactory();
DbBinaryExpression binaryExpression;
binaryExpression = factory.Subtract(factory.Constant(1), factory.Constant(2));
ValidateBinaryExpression(binaryExpression, DbBinaryExpressionType.Subtract);
}
public void ShouldCreateNowExpression()
{
var factory = new DbExpressionFactory();
DbDateTimeFunctionExpression dateTimeFunctionExpression;
dateTimeFunctionExpression = factory.Now();
ValidateDateTimeFunctionExpression(dateTimeFunctionExpression, DbDateTimeFunctionExpressionType.Now);
}
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 ShouldCreateTableExpression()
{
var factory = new DbExpressionFactory();
var expression = factory.Table("SomeTable");
Assert.IsNotNull(expression);
Assert.IsNotNull(expression.TableName);
Assert.IsTrue(expression.ExpressionType == DbExpressionType.Table);
}
public void ShouldCreateMillisecondExpression()
{
var factory = new DbExpressionFactory();
DbDateTimeFunctionExpression dateTimeFunctionExpression;
dateTimeFunctionExpression = factory.Millisecond(factory.Column("SomeDateTimeColumn"));
ValidateDateTimeFunctionExpression(dateTimeFunctionExpression, DbDateTimeFunctionExpressionType.MilliSecond);
}
public void ShouldCreateNotEqualOperatorOverloading()
{
var factory = new DbExpressionFactory();
var expression = (DbBinaryExpression)(factory.Column("SomeColumn") != 1);
Assert.AreEqual(DbBinaryExpressionType.NotEqual, expression.BinaryExpressionType);
}
public void ShouldCreateRoundExpression()
{
var factory = new DbExpressionFactory();
DbMathematicalFunctionExpression mathematicalFunctionExpression = factory.Round(factory.Column("SomeColumn"), factory.Constant(2));
ValidateMathematicalFunctionExpression(mathematicalFunctionExpression, DbMathematicalFunctionExpressionType.Round);
}
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 ShouldCreateOrUsingOperatorOverloading()
{
var factory = new DbExpressionFactory();
var expression = (DbBinaryExpression)(factory.Column("SomeColumn") | factory.Column("SomeOtherColumn"));
Assert.AreEqual(DbBinaryExpressionType.Or, expression.BinaryExpressionType);
}
public void ShouldReplaceExpressionsOfParticularTypeUsingPredicate()
{
var factory = new DbExpressionFactory();
var dbSelectQuery = new DbSelectQuery();
var expression = dbSelectQuery.Select(f => f.Column("SomeColumn")).From(f => f.Table("SomeTable"));
expression.Replace<DbTableExpression>(te => true, te => factory.Alias(te, "t0"));
var result = expression.Find<DbAliasExpression>(ae => true);
Assert.IsTrue(result.Count() == 1);
}
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 ShouldCreateTanExpression()
{
var factory = new DbExpressionFactory();
DbMathematicalFunctionExpression mathematicalFunctionExpression = factory.Tan(factory.Column("SomeColumn"));
ValidateMathematicalFunctionExpression(mathematicalFunctionExpression, DbMathematicalFunctionExpressionType.Tan);
}
public void ShouldCreateRandExpression()
{
var factory = new DbExpressionFactory();
DbMathematicalFunctionExpression mathematicalFunctionExpression = factory.Rand();
ValidateMathematicalFunctionExpression(mathematicalFunctionExpression, DbMathematicalFunctionExpressionType.Rand);
}
public void ShouldCreateSoundExExpression()
{
var factory = new DbExpressionFactory();
var stringFunctionExpression = factory.SoundEx(factory.Column("SomeStringColumn"));
ValidateStringFunctionExpression(stringFunctionExpression, DbStringFunctionExpressionType.SoundEx);
}
public void ShouldCreateLessThanUsingOperatorOverloading()
{
var factory = new DbExpressionFactory();
var expression = (DbBinaryExpression)(factory.Column("SomeColumn") < 1);
Assert.AreEqual(DbBinaryExpressionType.LessThan, expression.BinaryExpressionType);
}
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 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 ShouldCreateNotEqualExpression()
{
var factory = new DbExpressionFactory();
DbBinaryExpression binaryExpression;
binaryExpression = factory.NotEqual(factory.Constant(1), factory.Constant(2));
ValidateBinaryExpression(binaryExpression, DbBinaryExpressionType.NotEqual);
}
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 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 ShouldCreateLengthExpression()
{
var factory = new DbExpressionFactory();
var stringFunctionExpression = factory.Length(factory.Column("SomeStringColumn"));
ValidateStringFunctionExpression(stringFunctionExpression, DbStringFunctionExpressionType.Length);
}
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 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 ShouldCreateReverseExpression()
{
var factory = new DbExpressionFactory();
var stringFunctionExpression = factory.Reverse(factory.Column("SomeStringColumn"));
ValidateStringFunctionExpression(stringFunctionExpression, DbStringFunctionExpressionType.Reverse);
}
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 ShouldCreateRandWithSeedExpression()
{
var factory = new DbExpressionFactory();
DbMathematicalFunctionExpression mathematicalFunctionExpression = factory.Rand(factory.Constant(10));
ValidateMathematicalFunctionExpression(mathematicalFunctionExpression, DbMathematicalFunctionExpressionType.RandSeed);
}
