March 5, 2026 · 5 min read
Dapper maps C# strings to nvarchar(4000) by default. If your SQL Server column is varchar, every query silently scans every row instead of seeking the index.
January 30, 2026 · 5 min read
Stop running two queries for paginated results. Use COUNT(*) OVER() to get everything in one shot.