Document locking concept ?

microsoft.public.dotnet.framework.adonet

26 Jan 2006 10:56 AM

Marek

Hi !

I have problem with locking concept in my application (ADO.NET , C#).
Application has several documents which looks like Order.My question is what
and how should I lock those documents.
1.Lock document as a whole (Order + OrderLines) so another user can't work
on this document (pessimistic lock)?
1.1. How to implement this on SQL server ?
2.Should I use optimistic locking on Order and OrderLines ?
I3. If I use optimistic locking on OrderLines should I each time update
timestamp of Order and by each insert, update and read of OrderLine check
whether somebody has changed this Order and/or OrderLine which is both
possible ?

Any thoughts are appreciated!