How C# Strings Silently Kill Your SQL Server Indexes in Dapper

Hacker News
March 6, 2026
If you're using Dapper with anonymous objects to query varchar columns, you're probably sending nvarchar(4000) parameters — causing CONVERT_IMPLICIT on every row and defeating your indexes. Here's the fix.
Verticals
techstartups
Originally published on Hacker News on 3/6/2026