Using NHibernate With Stored Procedures - Ayende @ Rahien

link -> Using NHibernate With Stored Procedures - Ayende @ Rahien

I wonder if you could use something like this to do shift collation. The advantage being that another entity could map a PunchedShift as a reference instead of just a PunchedShiftID. I would rather it let me write code instead of SQL though.