I need a non-blocking transaction and the default behavior (at least
for Firebird) is that the transaction will wait forever if another
transaction has locked a row.
Is it possible to do one of the following:
1) Specify that the transaction should NOT wait for locks to be
released (instead it should throw a deadlock exception)?
2) Manually create a Firebird Transaction and attach it to the
ISession?
Or better yet:
3) How do I specify FbTransactionOptions.NoWait when using
ISession.BeginTransaction?
See
http://web.firebirdsql.org/dotnetfirebird/documentation/api/1.7/FirebirdSql.Data.Firebird.FbTransactionOptions.html
for docs.