WITH (nolock) in every SELECT - NHibernate
1 answer
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:
SQL Server NOLOCK hint and other bad ideas
ADDITIONAL LINKS:
+11
source to share