Pardon my ignorance but is there any documentation on FbTransaction and FbTransactionOptions?
What I want to do is start a transaction with IsolationLevel of snapshot, and with wait timeout of 1/10 second.
Here is what I've come up with, but not sure I've the correct behavior nor if this is even smart to do this
FbTransactionOptions fbopt = new FbTransactionOptions();
fbopt.WaitTimeout = new TimeSpan(1000000);
fbopt.TransactionBehavior = FbTransactionBehavior.Wait | FbTransactionBehavior.Concurrency;
using(FbTransaction trans = conn.BeginTransaction(fbopt))
Also, since this is a method called by many other methods, I would like to be able to change the IsolationLevel, in code, when needed. So is this the correct way to do it and is there any documentation what behavior equals what isolation level?