How will you avoid Concurrency conflicts ?

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