How will you avoid Concurrency conflicts ?

Friday, July 31, 2009


You can avoid Concurrency conflicts by match all or timestamp-based concurrency. That is when updating you need to check the current values with the db values.

Ex:
Update employee set empname=@ename, phone=@phone , salary=@salary
where empid=@orginalEmpid and designation=@orginalDesignation and managerid=@orginalmanagerid
.


www.codecollege.NET

0 comments

Post a Comment

www.codecollege.NET

Blog Widget by LinkWithin