public void CreateNotConditionTest() { AbstractDatabase fakeDb = DatabaseFactory.CreateDatabase("", "System.Data.SqlClient") as AbstractDatabase; SelectCommand expectedCommand = fakeDb.CreateSelectCommand(""); SelectCommand actualCommand = fakeDb.CreateSelectCommand(""); SqlConditionBuilder expectedConditionBuilder = expectedCommand.ConditionBuilder; SqlConditionBuilder actualConditionBuilder = expectedCommand.ConditionBuilder; SqlBasicParameterCondition baseCondition = expectedConditionBuilder.Equal("TestColumn2", 1); SqlNotCondition expectedCondition = !baseCondition; SqlNotCondition actualCondition = SqlLinqCondition.Create <TestEntity>(actualCommand, c => !(c.Test2 == 1)) as SqlNotCondition; Assert.AreEqual(expectedCondition, actualCondition); }
public void CreateNotConditionTest() { AbstractDatabase fakeDb = DatabaseFactory.CreateDatabase("", "System.Data.SqlClient") as AbstractDatabase; SelectCommand baseCommand = fakeDb.CreateSelectCommand(""); SqlConditionBuilder conditionBuilder = baseCommand.ConditionBuilder; SqlBasicParameterCondition baseCondition = conditionBuilder.Equal("TestColumn2", 1); SqlNotCondition actualCondition = !baseCondition; String expectedConditionClause = "(NOT((TestColumn2 = @PN_IDX_0)))"; String actualConditionClause = actualCondition.GetClauseText(); DataParameter[] expectedParameters = baseCondition.GetAllParameters(); DataParameter[] actualParameters = baseCondition.GetAllParameters(); Assert.AreEqual(expectedConditionClause, actualConditionClause); for (Int32 i = 0; i < expectedParameters.Length; i++) { Assert.AreEqual(expectedParameters[i], actualParameters[i]); } }