Where to start the transaction for a pessimistic concurrency????
My question is : Isn't true when dealing with pessimistic concurrency the transaction has to start in the client?
In other words, for example, you have a C# client window application that retrieves a record for updating from
a SQL Server database. You retrieve the record and you update it on the window screen and send it back to the sql server ---in this process you don't want anyone else grabbing that record for possible updating and so you must start the transaction on the client side and not in say a stored procedure on the sql server database.
Is that correct what I am saying?