KiwiQuery.EFCore 1.0.0

KiwiQuery

Assert the number of SQL queries EF Core executes in your integration tests. Catch N+1 problems before they hit production.

Tired of writing the same DbCommandInterceptor boilerplate in every project just to check if your endpoint makes too many queries? This is for you.

await using var guard = factory.TrackQueries<Program, AppDbContext>();
var client = guard.CreateClient();

await client.GetAsync("/api/orders");

guard.AssertCount(exact: 1);

Installation

dotnet add package KiwiQuery.EFCore

Requirements

• .NET 5+
• EF Core 5+
• Microsoft.AspNetCore.Mvc.Testing

Why

N+1 is one of those bugs that never shows up in unit tests — only in production, under load, when it's already too late. Writing a custom interceptor to catch it in integration tests is doable but tedious, and every team ends up copy-pasting the same 50 lines.

KiwiQuery wraps that into a single method call.

Usage

public class OrderTests : IClassFixture<WebApplicationFactory<Program>>
{
    private readonly WebApplicationFactory<Program> _factory;

    public OrderTests(WebApplicationFactory<Program> factory)
    {
        _factory = factory;
    }

    [Fact]
    public async Task GetOrders_ExecutesExactlyOneQuery()
    {
        await using var guard = _factory.TrackQueries<Program, AppDbContext>();
        var client = guard.CreateClient();

        await client.GetAsync("/api/orders");

        guard.AssertCount(exact: 1);
    }
}

Assertions

guard.AssertCount(exact: 1);              // exactly 1 query
guard.AssertAtMost(3);                    // no more than 3
guard.AssertAtLeast(1);                   // at least 1
guard.AssertCount(atLeast: 1, atMost: 3); // range
guard.AssertNoQueries();                  // nothing hit the DB

If you just want the number:

Console.WriteLine(guard.Count);

Multiple DbContext types

Target a specific one:

await using var guard = _factory.TrackQueries<Program, AppDbContext>();

Or let it find all of them:

await using var guard = _factory.TrackQueries<Program>();

Multiple requests

The counter accumulates — useful if you want to assert a budget across several calls:

await client.GetAsync("/api/orders");
await client.GetAsync("/api/products");

guard.AssertAtMost(2);

What gets counted

SELECT, INSERT, UPDATE, DELETE, WITH — anything that hits your actual data. PRAGMA, schema checks, connection setup are ignored. Seeding and EnsureCreated() on startup don't count either.

License

MIT