Dear All,
I am back with one more problem today.
I have ADO.NET application which inserts data to table. (ex Invoices)
I have written Transaction with IsolationLevel.ReadUncommitted in my ADO.net Application using c# code
Whenever i run this application and try to select data from my Invoices table, i am not able to do so.
ex:
When i fire below query from my sql query window when ADO.net Application is running,
Below query works,
select * from Invoices with(nolock,nowait)
Below query does not work,
select * from invoices
I know that when we use with(nolock,nowait) we can read uncommitted data, but i want to read only committed data, but it seems that the transaction is putting lock on my table and not allowing me to read any data.
I want to read only committed data.
What I have tried:
I Tried IsolationLevel.ReadCommitted,IsolationLevel.ReadUnCommitted in my ado.net Application
Please suggest what can be done in this situation.