Scope of OleDB locking

Question

Looking at OleDbConnection.BeginTransaction Method
https://learn.microsoft.com/en-us/dotnet/api/system.data.oledb.oledbconnection.begintransaction?view=dotnet-plat-ext-5.0

It is not clear, is the locking only within the same app instance ie one user using the database OR If have two users using the app on different machines will the record be locked against read by the second user?

Answer 1

Hi @Don Glover ,

As far as I know, when starting a transaction, it does not lock the database, but it ensures isolation of updates of the database in part related to the transaction. and it guards database consistency at all times.

Best Regards,
Xingyu Zhao
*
If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 2

The locking (actually isolation) is at the connection level. If your app used two connections, then they would also be locked against each other.