Page 1 of 1

Pesimistic Concurrency

Posted: Mon 25 Jan 2010 19:16
by acerdas
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

Posted: Wed 27 Jan 2010 09:49
by Shalex
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 ... level.aspx.