Yes, you *can* use stored procedures with NHibernate, but it's an edge case. As Ayende says in his post you loose querying and the primary productivity reason for choosing NHibernate in the first place, that it generates SQL for you.
If you are going to embrace NHibernate fully you need to get over the stored procedure fetish.
The point of the silly cartoon was that I have recently seen two examples of corporate development shops spend huge amounts of time and effort writing their own DAL code generators. When you ask them why they didn't just use NHibernate (or one of the 30 other ORM tools listed on Wikipedia) one of the main reasons given is they had to do all data access via stored procedures.
Notepad, thoughts out loud, learning in public, misunderstandings, mistakes. undiluted opinions. I'm Mike Hadlow, an itinerant developer. I live (and try to work in) Brighton on the south coast of England. Please don't mistake me for an expert in anything. I love technology and programming, but make no claims to be any good at it. Much of what you read here may be poorly thought out, wrong, or just plain dangerous.
Posts
6 comments:
Yes! :)
Does that say StoredProcs?
I thnk I'm missing the point: http://ayende.com/Blog/archive/2006/09/18/UsingNHibernateWithStoredProcedures.aspx
Steve,
Yes, you *can* use stored procedures with NHibernate, but it's an edge case. As Ayende says in his post you loose querying and the primary productivity reason for choosing NHibernate in the first place, that it generates SQL for you.
If you are going to embrace NHibernate fully you need to get over the stored procedure fetish.
The point of the silly cartoon was that I have recently seen two examples of corporate development shops spend huge amounts of time and effort writing their own DAL code generators. When you ask them why they didn't just use NHibernate (or one of the 30 other ORM tools listed on Wikipedia) one of the main reasons given is they had to do all data access via stored procedures.
That's pretty funny Mike, I like the rapidly receding hairline.
Randall Munroe better watch out ;)
You can't use ORMs in every situation, I never found ORM easier, better or faster in reporting tools. Unless I'm missing something?
Wayne-o,
Agreed, they don't really make sense for reporting.
Post a Comment