I've been fielding questions on this topic and struggled for a cohesive answer. Should some people wait until LINQ to Entities and the ADO.NET Entity framework is shipped or go LINQ to SQL now?
I saw on Kirk Allen Evan's Blog a pointer to a MSDN Article on this very question.
Introducing LINQ to Relational Data
Summary: This article introduces two implementations of LINQ, LINQ to SQL and LINQ to Entities, and the key scenarios for which each was designed. (19 printed pages)
- Troy.