Locking Database
Database
1
Posts
1
Posters
0
Views
1
Watching
-
Hi All, I have .net webservice [with sybase backend], which Adds/Updates/Deletes the customer details. Considering the services is deployed on server where database also resides, if more than two clients requests[a multi-user environment] the same Update service, problems regarding the database locking arises. I think record-level locking would be the better solution for handling datase locking issues related to Updates. for Inserts and Deletes actions using page loaking would be better. Transaction obejct in .net have Isolation enums which can simulate these , odes anyone incrporated these. Can Somebody help me out to solve these situation or any related links is appreciated. Regards, Vinay