Anko Duizer is spot on with his post on the top 5 problems with LINQ to SQL. I’d like to take this opportunity to express my biggest concern with LINQ to SQL.
#6 LINQ to SQL is intended for direct 1-1 mapping of a Microsoft SQL server database to .NET classes. LINQ to SQL is not a natural fit in typical enterprise scenarios.