WITH (nolock) in every SELECT - NHibernate
Set your database transaction isolation level to
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED
NOLOCK is equivalent to READUNCOMMITED, so you get the same effect if your connection is using a transaction isolation level.
ATTENTION! DANGER! READ IT!!!
This is the best explanation I have ever seen in NOLOCK HINT (and HINTS in general). It's worth reading:
source to share