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