Hello:
I am trying to research how to handle concurrency problem in .net application.
Group A users can see only records assigned to them but B can see all. If B pulls the records and then A edits/Updates his records and then B updates - B overwrite A without enen knowing it.
Is is a solvable problem? I read about various methods but none of them seems to be really working. Locking apparently is not applicable here due to disconnect nature of database.
Can you assist? - users are upset as there is a loss of time and data that is happening here.
Using SQL database and C# and ASP.net 2.0
...
Go to the complete details ...