Useful LINQ to SQL links

I like LINQ to SQL, but I get occasionally caught out when trying something that seems like it should work. It compiles fine, but when you run the code you get: “Static method blah blah blah has no supported translation to SQL.”

This http://msdn.microsoft.com/en-us/library/bb386970.aspx details what methods and types are supported by LINQ to SQL.

Goto http://msdn.microsoft.com/en-us/library/bb386934.aspx for a general reference.