LINQ to SQL cache problem

Posted on August 29, 2008

2


This is an interesting article on an issue with LINQ to SQL and what SQL Server does with procedure caching coming from LINQ.

http://blogs.lessthandot.com/index.php/DataMgmt/DataDesign/linq-to-sql-queries-involving-strings-ca

In summary, each where condition depending on the size of the value will cause a different plan to be created – e.g if the value passed into a WHERE clause was ‘This Value’ and another was ‘Another Value’ – two entries will be kept in the procedure cache…  one a NVARCHAR (10) and another NVARCHAR (13)..

I have no checked SP1 to see if this is resolved. If anyone knows, please let me know.

Advertisements
Posted in: Article, News, sql 2008