They shouldn't be allowed near a SQL Server, at least not a production one. There, I said it! 😀

There really are lots of reasons to avoid these for any app that needs (or may need) to scale or have good concurrency.

What about sproc enforcement? Well, at least with LINQ to SQL you introduce some restrictions with what you can do in the sproc, such as use temporary tables. I wouldn't be surprised if others don't have limitations about what types of metadata and operations they can interogate or accept in sprocs.

The businessman in me WANTs everyone in the world to use ORMs for SQL Server development. I get paid good money to clean up the messes they can leave behind. 😎