Start Debugging

Tag: sql-server

5 posts

2026-05-01 csharp dotnet dotnet-11

How to write integration tests against a real SQL Server with Testcontainers

A complete guide to running ASP.NET Core integration tests against a real SQL Server 2022 using Testcontainers 4.11 and EF Core 11: WebApplicationFactory wiring, IAsyncLifetime, swapping the DbContext registration, applying migrations, parallelism, Ryuk cleanup, and CI gotchas.

2026-04-20 dotnet-11 ef-core-11 sql-server

EF Core 11 translates Contains to JSON_CONTAINS on SQL Server 2025

EF Core 11 auto-translates LINQ Contains over JSON collections to the new SQL Server 2025 JSON_CONTAINS function, and adds EF.Functions.JsonContains for path-scoped and mode-specific queries that can hit a JSON index.

2026-04-18 ef-core dotnet-11 sql-server

EF Core 11 Prunes Unnecessary Reference Joins in Split Queries

EF Core 11 Preview 3 removes redundant to-one joins from split queries and drops unneeded ORDER BY keys. One reported scenario got 29% faster, another 22%. Here is what the SQL now looks like.

2026-04-14 csharp dotnet sql-server

How Dapper's Default nvarchar Parameters Silently Kill Your SQL Server Indexes

C# strings sent through Dapper default to nvarchar(4000), forcing SQL Server into implicit conversions and full index scans. Here's how to fix it with DbType.AnsiString.

2026-04-13 dotnet-11 ef-core sql-server

EF Core 11 Adds Native SQL Server Vector Search with DiskANN Indexes

EF Core 11 Preview 2 supports SQL Server 2025 VECTOR_SEARCH() and DiskANN vector indexes directly from LINQ. Here is how to set up the index, run approximate queries, and what changes from the EF Core 10 VectorDistance approach.