Kevin Griffin

Independent software consultant specializing in ASP.NET Core, Microsoft Azure, and modern web development. 17-time Microsoft MVP.

Popular posts: 1
Total points: 126
HN comments: 126
Rank: #18,167 personal

Visit consultwithgriff.com → On Hacker News Mar 2026 – Mar 2026

Software Engineering 1 Databases & Data 1

Most points Most discussed Most cited Newest

C# strings silently kill your SQL Server indexes in Dapper

2026126 points126 comments Databases & Data details

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.