Start Debugging

Tag: sql-server

13 posts · Page 2 of 2

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.