I keep getting asked this one. I have my own way of answering which ultimately ends up with “LINQ to Entities is the right choice for majority of scenarios, just expect a little pain”. In slightly more detail:
However I thought it was time I had a look for an “official” answer. In Jan 2008 Elisa published a document on “LINQ to Relational” covering both technologies which contained the following two tables.
LINQ to SQL
LINQ to Entities