I've experimented with LINQ and find it compelling. As a developer turned DBA, to use LINQ in a production way would require a big shift in thinking. I was taught as a developer/DBA that an application must always interact with the database via stored procedures. This methodology causes extended debates, but we'll set that aside for now.

Based on my experimentation, you can still restrict the application to stored procedures, but doing so appears to negate the productivity gains LINQ offers. So now I am faced with faced with the prospect of reversing everything I've preached for the last eight years, and give table access to the application. I may do that, but will be a real cultural shift for me personally.