Lean LINQ Tips
LINQ allows users to query any data source in a unified way. However, even with the LINQ standard query operators, used to create these queries, it’s easy to misuse these operators unless you have a solid understanding of how they work internally. Such misuse leads to inefficient queries that are slower—in some cases much slower—than the equivalent properly tuned query.
For example, .NET 4.0 offers implicit typing, in which the compiler figures out the intended data type of a query result at runtime. That’s convenient, so developers tend to be comfortable projecting the result to a strongly typed collection like List<T> ...