You asked why I'm still a proponent of Stored procs - tell you what...fire up the latest CTP or Beta that you have, and create some linq to sql queries between related master and child tables. Make sure to rollup some currency columns.
Then look at the generated SQL code.
Then you may realize what most Oracle people and a number of SQL Server people are saying - that they'd rather write their own sproc code.