LINQ to SQL cache problem

Posted on August 29, 2008


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

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.

Posted in: Article, News, sql 2008