Pesimistic Concurrency

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for Oracle
Post Reply
acerdas
Posts: 2
Joined: Fri 22 Jan 2010 16:50

Pesimistic Concurrency

Post by 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

Shalex
Site Admin
Posts: 9543
Joined: Thu 14 Aug 2008 12:44

Post by 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 ... level.aspx.

Post Reply