LINQ to SharePoint Performance Pitfalls
SharePoint 2010 introduced LINQ to SharePoint which enables the programmer an easy access to SharePoint lists and content types using LINQ.
While LINQ to SharePoint greatly simplifies the code and frees the programmer from writing CAML queries, it can easily result in poor code in terms of performance. The main problem is, IMHO, that the full power of…