C# strings silently kill your SQL Server indexes in Dapper

Automated excerpt

This helps SQL Server match the parameter type exactly to the column type and reuse cached query plans efficiently. Just telling Dapper the correct parameter type. Match the parameter type to the column type, and match the size to the column size.

Selected automatically from source text; not independently written or fact-checked. Read the original for full context.