Friday, April 18, 2008 3:15 AM
I had an interesting conversation with Donald and Tom over lunch today around the stored procedures and their relevance to software development today. Their argument is that stored procedures have no value when a solution is utilizing an ORM mechanism (like NHibernate) because the ORM creates/maintains the database SQL queries. You end up with having to maintain and manage an extra layer when you incorporate SP's into the mix in this scenario.
Although they had good points, this seemed to work well only with CRUD based calls (which does tend to be the majority of the database interactions done within a system). I can still see a need for using SP's for complex reporting outputs, and although I'm sure there's an answer to this, I'm not aware of how transactional procedures are carried out within tools like NHibernate as opposed to implementing database trasnactions. (heh, although I'm expecting some comments from Donald and Tom on this post).
Anyway, just some thoughts...what are yours?
D