c# - Dead lock while using Repeatable Read Isolation level sql -


recently team done project on asp.net c# . add features exisiting project done other company.

its shopping cart. when user places order in rare cases running dead lock situation , database connections being lost established through entripise library

error : transaction (process id 89) deadlocked on lock resources process , has been chosen deadlock victim. rerun transaction.

so searched various reasons occurance of dead lock came know exact reaosn dead lock

reason :

dbwrapper wrapper = new dbwrapper(true,system.data.isolationlevel.repeatableread); 

using of isolationlevel.repeatableread causing dead lock issue.

so have bit poor knowledge on locks concept in sql.

expected sloutions:

1) plan change isolation level similar behaviour isolationlevel.repeatableread , prevent dead lock occurance.

2) or else keeping same isolation level in code , make sql query lock concept , make work successful.

please high priority issue us... thoughts highly appreciated.

please suggest me expected solution.


Comments

Popular posts from this blog

php - failed to open stream: HTTP request failed! HTTP/1.0 400 Bad Request -

java - How to filter a backspace keyboard input -

java - Show Soft Keyboard when EditText Appears -