Using nHibernate, how can I read uncommited?

Question

Hi,

Using nhibernate, how can I set the transaction level to read uncommitted?

With SQL, I usually set the transaction level at teh beginning of my stored procedure or use inline (NOLOCK).

Answer 1

According to the documentation, you can set it via hibernate.connection.isolation. If you need more precise control, look into NHibernate's pessimistic locking mechanisms.