public void LinqCreateNotBetweenConditionTest()
{
AbstractDatabase fakeDb = DatabaseFactory.CreateDatabase("", "System.Data.SqlClient") as AbstractDatabase;
SelectCommand expectedCommand = fakeDb.CreateSelectCommand("");
SelectCommand actualCommand = fakeDb.CreateSelectCommand("");
SqlConditionBuilder expectedConditionBuilder = expectedCommand.ConditionBuilder;
SqlBasicParameterCondition expectedCondition = expectedConditionBuilder.NotBetween("TestColumn1", "1", "2");
SqlBasicParameterCondition actualCondition = SqlLinqCondition.Create <TestEntity>(actualCommand, c => c.Test1.NotBetween("1", "2")) as SqlBasicParameterCondition;
Assert.AreEqual(expectedCondition, actualCondition);
SqlBasicParameterCondition expectedCondition2 = expectedConditionBuilder.NotBetween("TestColumn2", 1, 2);
SqlBasicParameterCondition actualCondition2 = SqlLinqCondition.Create <TestEntity>(actualCommand, c => c.Test2.NotBetween(1, 2)) as SqlBasicParameterCondition;
Assert.AreEqual(expectedCondition2, actualCondition2);
SqlBasicParameterCondition expectedCondition3 = expectedConditionBuilder.NotBetween("TestColumn5", 1, 2);
SqlBasicParameterCondition actualCondition3 = SqlLinqCondition.Create <TestEntity>(actualCommand, c => c.Test5.NotBetween(1, 2)) as SqlBasicParameterCondition;
Assert.AreEqual(expectedCondition3, actualCondition3);
}
