As a guy that came up through the data side of the house I am very accustomed to writing stored procedures as the interaction between database and application. On my current project we are using L2SQL for that interaction and while most things have been acceptable I would not call it a pleasant experience. Most of my concern has come from actually looking under the covers at the generated SQL and being absolutely appalled at some of the things I have seen. In those cases we have fallen back to stored procedures, which in an odd way has been disappointing as I had hoped we would only do one or the other.
I have hope for the future based on a post on the ADO.NET team blog about improvements they are making in the generated SQL of Entity Framework. I believe that EF will be the future for most data driven applications (whether you find that idea palatable or not) so I am happy to see early realization that version one has a long way to go in terms of generating quality SQL.
I am curious though to hear from the fine readers of this blog if you are still in stored procedure land or if your development team(s) kicked the tires on either EF or L2SQL.
704e734a-2d02-43aa-9091-1b0db103a9d3|2|5.0