Using parameterized queries seems to set the parameter length for the length of the passed value.
Doing something like:
var person = Connection.Query<People>("select * from People where Name = @name", new { name = "Fred"});
Forces the parameter to be NVARCHAR (4), so the next request with different lengths gets the missing information about the cached plans and creates a new one.
How can I change it so that it just uses the specified length.
Phill source share