I would like to find a way to lock a row so that other threads could not read from that row until it is manually unlocked. I have a multi-threaded application that sometimes has two threads modifying the same row. This happens rarely so it would be acceptable to make the second thread to access the row wait until the first is done. Is there a way to make the locking happen within NHibernate (or at the db [MSSQL]), or should I do this manually with Monitors.

Thanks

Have a look here:

http://nhforge.org/doc/nh/en/index.html#transactions-locking