search

ralmsdeveloper / EntityFrameworkCore.FirebirdSQL

FirebirdSQL database provider for Entity Framework Core.
Other
44 stars 26 forks source link

FOR UPDATE WITH LOCK And NOWAIT Read Commited Isolation Level Transactions #50

Closed arabasso closed 4 years ago

arabasso commented 4 years ago

Hello!

I am trying to use FOR UPDATE WITH LOCK in version 7.1.1, however I have verified that transactions are being created with FbTransactionBehavior.NOWAIT... In the library code the problem is on line 248 of the BuildTpb() method (Provider\src\FirebirdSql.Data.FirebirdClient\FirebirdClient\FbTransaction.cs):

options.TransactionBehavior |= FbTransactionBehavior.NoWait;

So, I ask: How can I disable FbTransactionBehavior.NOWAIT in Entity Framework Core if I can't manage directly the transactions (context.Database.BeginTransaction(IsolationLevel.ReadCommited))?