public void Should_Return_Correct_Sql_For_Negated_Query()
{
using (var fixture = new QueryProviderFixture())
{
// Given
fixture.Initialize(Configure);
// When
var result = fixture.ToSql <Invoice>("!Paid");
// Then
result.ShouldBe("SELECT Invoices.* FROM Invoices WHERE NOT Invoices.Paid = 1");
}
}
public void Should_Return_Correct_Sql_For_Null_Comparison()
{
using (var fixture = new QueryProviderFixture())
{
// Given
fixture.Initialize(Configure);
// When
var result = fixture.ToSql <Invoice>("Comment != null");
// Then
result.ShouldBe("SELECT Invoices.* FROM Invoices WHERE Invoices.Comment IS NOT NULL");
}
}
