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
Post a Comment