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");
}
}
public void Should_Return_Correct_Data_For_Greater_Than_Comparison()
{
using (var fixture = new QueryProviderFixture(Seed))
{
// Given
fixture.Initialize(Configure);
// When
var result = fixture.Query <Invoice>("ID > 4");
// Then
result.Count.ShouldBe(1);
result[0].As(invoice => invoice.InvoiceId.ShouldBe(5));
}
}
public void Should_Return_Correct_Data_For_Null_Comparison_Against_Nullable_Boolean()
{
using (var fixture = new QueryProviderFixture(Seed))
{
// Given
fixture.Initialize(Configure);
// When
var result = fixture.Query <Invoice>("Discount = null");
// Then
result.Count.ShouldBe(1);
result[0].InvoiceId.ShouldBe(5);
}
}
public void Should_Return_Correct_Data_For_Null_Comparison_Against_Reference_Type()
{
using (var fixture = new QueryProviderFixture(Seed))
{
// Given
fixture.Initialize(Configure);
// When
var result = fixture.Query <Invoice>("Comment != null");
// Then
result.Count.ShouldBe(1);
result[0].InvoiceId.ShouldBe(3);
}
}
public void Should_Return_Correct_Data_For_Conversion_Between_Nullable_And_Non_Nullable_Comparison()
{
using (var fixture = new QueryProviderFixture(Seed))
{
// Given
fixture.Initialize(Configure);
// When
var result = fixture.Query <Invoice>("Discount = 20");
// Then
result.Count.ShouldBe(1);
result[0].InvoiceId.ShouldBe(4);
}
}
public void Should_Return_Correct_Data_For_Negated_Query()
{
using (var fixture = new QueryProviderFixture(Seed))
{
// Given
fixture.Initialize(Configure);
// When
var result = fixture.Query <Invoice>("!Paid");
// Then
result.Count.ShouldBe(1);
result[0].As(invoice => invoice.InvoiceId.ShouldBe(4));
}
}
public void Should_Return_Correct_Data_For_Simplified_Boolean()
{
using (var fixture = new QueryProviderFixture(Seeder))
{
// Given
fixture.Initialize(Configure);
// When
var result = fixture.Query <Invoice>("Paid");
// Then
result.Count.ShouldBe(3);
result[0].InvoiceId.ShouldBe(1);
result[1].InvoiceId.ShouldBe(2);
result[2].InvoiceId.ShouldBe(3);
}
}
public void Should_Return_Correct_Data_For_Relational_Query()
{
using (var fixture = new QueryProviderFixture(Seeder))
{
// Given
fixture.Initialize(Configure);
// When
var result = fixture.Query <Invoice>("ID = 1");
// Then
result.Count.ShouldBe(1);
result[0].As(invoice =>
{
invoice.InvoiceId.ShouldBe(1);
});
}
}
