There seems to be alot of haters out their for this concept. Everyone claims that LINQ to Entities is the way to go in the future. I don't have enough experience with LINQ to Entities to make a solid argument at this time.
What I do know is I have been using LINQ in both MVC and Web Form projects for the past 18 months and do not want to go back to ADO. Using a ORM tool like LINQ makes starting up projects super fast. Most projects these days are small in size anyway starting out and LINQ just makes those so easy. If the software is a success and grows then we can look at something else. That something else might still be LINQ for me though. Tools like
PLINQO from
Code Smith show hope for LINQ as a true DAL in big projects. I am evaluating it now for my next big project.