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.
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