Write a test proving stale updates return 409 and do not overwrite the winning value.

• Do not use EF Core InMemory for relational concurrency proof.
• Use independent DbContexts or HTTP clients.
• Assert response and final database state.
• Dispose the test database after the suite.

I deliberately create stale state, then send the losing request through HTTP. The final database read is as important as the 409 assertion because it proves no silent overwrite occurred.

[Fact]
public async Task Stale_update_returns_conflict_without_overwrite()
{
    await using var factory = await ApiTestFactory.WithIsolatedDatabaseAsync();
    var clientA = factory.CreateAuthenticatedClient("editor-a", "content.update");
    var clientB = factory.CreateAuthenticatedClient("editor-b", "content.update");

    var originalA = await clientA.GetFromJsonAsync<ContentDto>("/api/content/item-1");
    var originalB = await clientB.GetFromJsonAsync<ContentDto>("/api/content/item-1");

    var won = await clientA.PutAsJsonAsync("/api/content/item-1",
        new { Text = "first", Version = originalA!.Version });
    won.EnsureSuccessStatusCode();

    var lost = await clientB.PutAsJsonAsync("/api/content/item-1",
        new { Text = "second", Version = originalB!.Version });
    Assert.Equal(HttpStatusCode.Conflict, lost.StatusCode);

    var stored = await factory.ReadContentAsync("item-1");
    Assert.Equal("first", stored.Text);
}

Relational behavior is the subject of the test, so an isolated real provider is required. One small container can be shared safely per test collection if each test gets its own database/schema or transaction strategy.

• The row is deleted between reads.
• Both clients submit identical values.
• The API returns a fresh version after success.
• Parallel tests share one record id.

• Verify the ProblemDetails conflict code.
• Read stored state with a fresh context.
• Run against the production database provider in a disposable environment.

• Using one DbContext so stale state is never reproduced.
• Using InMemory and assuming concurrency matches SQL.
• Asserting only 409 without stored state.
• Retrying the stale write automatically.