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.