Looking for a way to obtain a REPEATABLE READ lock on a given NH instance on MS SQL. This can be accomplished with a special table hint on MS SQL. I would hope that LockMode would have this, but it doesn't seem to.

The basic idea is the record is locked for writers, but not for other readers.

use



Everything within that transaction will then use REPEATABLE READ just like you wanted. I hope that helps and you aren't just trying to use that isolation level on only one table.