Did you know that ADO.NET implicitly converts a parameterized ad-hoc SQL into a call to sp_executesql? Did you further know that if you do not explicitly tell ADO.NET the SqlDbType of your parameter, ...