How to do a write and read operation inside the same transaction?

Asked Sep 28 '15 at 12:15

Active Sep 28 '15 at 12:15

Viewed 170 times

I have a big ASP.NET transaction, with many operations. (using sql server)

Transaction started
Application updates a table (Let's name it T1)
Application performs some other actions
Application calls a webservice (which performs many actions)
Application Calls a 2nd webservice
On the 2nd webservice, I need to read from T1, and I'm getting a deadlock since the transaction was not commited yet

How can I solve this?

Thanks!

asked Sep 28 '15 at 12:15

Fabio TJK

Try specifying READ_UNCOMMITED as Isolation on transaction level, check this link https://msdn.microsoft.com/en-us/library/ms173763.aspx – Iztoksson Sep 28 '15 at 12:43
Thanks! I'm running some tests – Fabio TJK Sep 30 '15 at 15:17

0 Answers0