Pesimistic Concurrency

Pesimistic Concurrency

Postby acerdas » Mon 25 Jan 2010 19:16

Hello, how can I implement with transactionscope pesimistic concurrecy, i mean, to recover the entity from the db and lock the record, something similar to

Select * from xxx for update

thanks
acerdas
 
Posts: 2
Joined: Fri 22 Jan 2010 16:50

Postby Shalex » Wed 27 Jan 2010 09:49

Please set the IsolationLevel property of your OracleTransaction object to System.Data.IsolationLevel.Serializable. For more information, please refer to http://msdn.microsoft.com/en-us/library/system.transactions.isolationlevel.aspx.
Shalex
Devart Team
 
Posts: 7391
Joined: Thu 14 Aug 2008 12:44


Return to dotConnect for Oracle