I understand how NHibernate separates the persistent db structure from the logic and how the mapping works, but how do you guys handle data intensive actions, complex select scenarios, data maintenance, etc? We use stored procedures for things like these and we actually have quite a few of them.
Now what is the recommended practice? Is separate set of stored procedures for each db back-end the way to go?