The environment I work in requires that I use (NOLOCK) whenever possible to prevent other processes from failing due to locking during table scans, etc (of course, we also try to prevent those :)).

Anyway, I was wondering if this was even possible with nhibernate at this point. I am fairly familiar with it (I have been using it for about two months) but haven't seen it mentioned anywhere and couldn't find anything in the source.

I don't mind hacking the source myself to add this, if someone could just point me in the right direction. I'm not even sure where it would belong.

I think you'll want to look at the Transaction Isolation levels and telling NHibernate to use READ UNCOMMITED which is basically the name thing as using a NOLOCK hint on a single query.

BOb

Thanks for the info. Cheers!