I sat down to write a defense of stored procedures with specific regard to DAL/ORM solutions, but found myself painted into a corner. When it comes to generated code, many of the benefits of stored procedures start to crumble - or, at least, deny the luxury of automated approaches.