Hi, I am using asp.net with SQL2008 facing a concurrent user issue, if 2 users launches the application and clicks save then it is allowing to save the record twice. I need to avoid saving duplicate record. How can i acheive this?
1 thing i thought of taking Modifiedat value at the time of launching and comparing this value with database record if it differs then i will display message to 2nd user. Now the problem is we have migrated records which has same data of modifiedat.
Can any one let us know the best way to handle concurrency issue.
Your help is much appreciated.
-Mani