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