阅读背景:

ADO.NET:安全地为所有VarChar参数指定SqlParameter.Size的-1?

来源:互联网 

We have an existing body of C# code that calls parameterized ad-hoc SQL Server queries in many places. We never specify SqlParameter.Size, and it's documented that in this case, the SqlParameter class infers the size from the parameter value. We just recently became aware of the SQL Server plan cache pollution issues this creates, where a separate plan is cached for each distinct combination of parameter sizes.We have an existing body of C# code that calls




你的当前访问异常,请进行认证后继续阅读剩余内容。

分享到: