Introduction Declarative language constructs like query comprehension syntax often worries imperatively trained developers. I hear this quite a bit, and the excuse of “It Just Works” is often not satisfactory for most of them :-). Combine this with interesting behavioral differences like lazy evaluation and lots of developers get lost in paradise. Actually the perceived problem is not with LINQ itself, typically a lack of solid understanding about the query execution model causes grief.
Basic introduction to LINQ Query syntax Read Post
Learning all fundamentals about LINQ, i.e. data type var, anonymous types, lambda expressions, LINQ syntax and LINQ queries Read Post