Mike Taulty has two excellent posts on understanding how LINQ to SQL works, the difference between IEnumerable<T> and IQueryable<T> and more. While some people prefer to just follow the examples and use it, there are plenty (like me) that want to understand what's going on underneath. This makes planning and troubleshooting much simpler as well as sates our inherent “why is the sky blue” curiosity!
Deconstructing LINQ to SQL Part 1
Deconstructing LINQ to SQL Part 2
I was also relieved to read that someone with his mind also has a hard time with posts like the one where Matt Warren from Microsoft explains the same concepts. Matt is very close to the technology and is able to make a lot of leaps of understanding and I definitely have to read those types of posts over a few times and hurt my head a little before I get to an “aha!”. Mike has done a great job of translator.