BPM Directive - ReadUncommitted possible? (nolock)

ERP 10
1

Is it possible in BPM Method Directives to create a query or read a table in custom code in a read-only transaction block? I’m hoping this would be a work-around for my duplicating ttOrderDtl records in my BPM that verifies available demand. Thanks.

2

I found the answer, although it doesn’t solve my initial dupe records problem but it might be helpful for others.

 var xOptions = new System.Transactions.TransactionOptions();
 xOptions.IsolationLevel = System.Transactions.IsolationLevel.RepeatableRead;
 using (var t = new System.Transactions.TransactionScope(System.Transactions.TransactionScopeOption.Required, xOptions))
 {
      .
      .
      .
 }
2 Likes