How to read uncommitted data in nHibernate transaction?

Question

I would like to know to know how to read uncommitted data. I have an application which is saving an entry into table1 and then tries to read some entry from same table. I am unable to do that because the data gets locked between begin transaction and end transaction.

I read up on the net and I feel that by seting isolationlevel= ReadUnCommitted, I should be able to handle it. But It doesn't seem to work.

Please refer to my earlier post to get more details: StackOverflow post

Here is my solution. stackoverflow.com/questions/1302746/… — Tola Ch.
– Tola Ch., Commented Sep 15, 2016 at 18:40

Onur Gumus · Accepted Answer · 2014-04-10 18:46:13Z

0

I assume you use SQL Server , since in Oracle and some others ReadUncommitted is not supported. For sql server, ReadUncommitted should work. Alternatively you can send an adhoc query from nhibernate and add with (nolock) to your query and it will read uncommitted data

answered Apr 10, 2014 at 18:46

Onur Gumus

1,44913 silver badges29 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Arti Over a year ago

Yes I am using SQL server. Can you please give me more details on send adhoc query and add nolock. How can I do that? I am new to nHibernate. Please provide some link to refer to.

Collectives™ on Stack Overflow

How to read uncommitted data in nHibernate transaction?

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related