private TransactionParameterBuffer BuildTpb(IsolationLevel isolationLevel)
{
TransactionParameterBuffer tpb = this.db.CreateTransactionParameterBuffer();
tpb.Append(IscCodes.isc_tpb_version3);
tpb.Append(IscCodes.isc_tpb_write);
tpb.Append(IscCodes.isc_tpb_wait);
/* Isolation level */
switch (isolationLevel)
{
case IsolationLevel.Serializable:
tpb.Append(IscCodes.isc_tpb_consistency);
break;
case IsolationLevel.RepeatableRead:
tpb.Append(IscCodes.isc_tpb_concurrency);
break;
case IsolationLevel.ReadUncommitted:
tpb.Append(IscCodes.isc_tpb_read_committed);
tpb.Append(IscCodes.isc_tpb_rec_version);
break;
case IsolationLevel.ReadCommitted:
default:
tpb.Append(IscCodes.isc_tpb_read_committed);
tpb.Append(IscCodes.isc_tpb_no_rec_version);
break;
}
return(tpb);
}
private static TransactionParameterBuffer BuildTpb(FbTransactionOptions options)
{
var tpb = new TransactionParameterBuffer();
tpb.Append(IscCodes.isc_tpb_version3);
if (options.TransactionBehavior.HasFlag(FbTransactionBehavior.Consistency))
{
tpb.Append(IscCodes.isc_tpb_consistency);
}
if (options.TransactionBehavior.HasFlag(FbTransactionBehavior.Concurrency))
{
tpb.Append(IscCodes.isc_tpb_concurrency);
}
if (options.TransactionBehavior.HasFlag(FbTransactionBehavior.Wait))
{
tpb.Append(IscCodes.isc_tpb_wait);
if (options.WaitTimeoutTPBValue.HasValue)
{
tpb.Append(IscCodes.isc_tpb_lock_timeout, (short)options.WaitTimeoutTPBValue);
}
}
if (options.TransactionBehavior.HasFlag(FbTransactionBehavior.NoWait))
{
tpb.Append(IscCodes.isc_tpb_nowait);
}
if (options.TransactionBehavior.HasFlag(FbTransactionBehavior.Read))
{
tpb.Append(IscCodes.isc_tpb_read);
}
if (options.TransactionBehavior.HasFlag(FbTransactionBehavior.Write))
{
tpb.Append(IscCodes.isc_tpb_write);
}
foreach (var table in options.LockTables)
{
int lockType;
if (table.Value.HasFlag(FbTransactionBehavior.LockRead))
{
lockType = IscCodes.isc_tpb_lock_read;
}
else if (table.Value.HasFlag(FbTransactionBehavior.LockWrite))
{
lockType = IscCodes.isc_tpb_lock_write;
}
else
{
throw new ArgumentException("Must specify either LockRead or LockWrite.");
}
tpb.Append(lockType, table.Key);
int?lockBehavior = null;
if (table.Value.HasFlag(FbTransactionBehavior.Exclusive))
{
lockBehavior = IscCodes.isc_tpb_exclusive;
}
else if (table.Value.HasFlag(FbTransactionBehavior.Protected))
{
lockBehavior = IscCodes.isc_tpb_protected;
}
else if (table.Value.HasFlag(FbTransactionBehavior.Shared))
{
lockBehavior = IscCodes.isc_tpb_shared;
}
if (lockBehavior.HasValue)
{
tpb.Append((int)lockBehavior);
}
}
if (options.TransactionBehavior.HasFlag(FbTransactionBehavior.ReadCommitted))
{
tpb.Append(IscCodes.isc_tpb_read_committed);
}
if (options.TransactionBehavior.HasFlag(FbTransactionBehavior.Autocommit))
{
tpb.Append(IscCodes.isc_tpb_autocommit);
}
if (options.TransactionBehavior.HasFlag(FbTransactionBehavior.RecVersion))
{
tpb.Append(IscCodes.isc_tpb_rec_version);
}
if (options.TransactionBehavior.HasFlag(FbTransactionBehavior.NoRecVersion))
{
tpb.Append(IscCodes.isc_tpb_no_rec_version);
}
if (options.TransactionBehavior.HasFlag(FbTransactionBehavior.RestartRequests))
{
tpb.Append(IscCodes.isc_tpb_restart_requests);
}
if (options.TransactionBehavior.HasFlag(FbTransactionBehavior.NoAutoUndo))
{
tpb.Append(IscCodes.isc_tpb_no_auto_undo);
}
if (options.TransactionBehavior.HasFlag(FbTransactionBehavior.ReadConsistency))
{
tpb.Append(IscCodes.isc_tpb_read_consistency);
}
return(tpb);
}
private TransactionParameterBuffer BuildTpb(FbTransactionOptions options)
{
TransactionParameterBuffer tpb = new TransactionParameterBuffer();
tpb.Append(IscCodes.isc_tpb_version3);
if ((options & FbTransactionOptions.Consistency) == FbTransactionOptions.Consistency)
{
tpb.Append(IscCodes.isc_tpb_consistency);
}
if ((options & FbTransactionOptions.Concurrency) == FbTransactionOptions.Concurrency)
{
tpb.Append(IscCodes.isc_tpb_concurrency);
}
if ((options & FbTransactionOptions.Shared) == FbTransactionOptions.Shared)
{
tpb.Append(IscCodes.isc_tpb_shared);
}
if ((options & FbTransactionOptions.Protected) == FbTransactionOptions.Protected)
{
tpb.Append(IscCodes.isc_tpb_protected);
}
if ((options & FbTransactionOptions.Exclusive) == FbTransactionOptions.Exclusive)
{
tpb.Append(IscCodes.isc_tpb_exclusive);
}
if ((options & FbTransactionOptions.Wait) == FbTransactionOptions.Wait)
{
tpb.Append(IscCodes.isc_tpb_wait);
}
if ((options & FbTransactionOptions.NoWait) == FbTransactionOptions.NoWait)
{
tpb.Append(IscCodes.isc_tpb_nowait);
}
if ((options & FbTransactionOptions.Read) == FbTransactionOptions.Read)
{
tpb.Append(IscCodes.isc_tpb_read);
}
if ((options & FbTransactionOptions.Write) == FbTransactionOptions.Write)
{
tpb.Append(IscCodes.isc_tpb_write);
}
if ((options & FbTransactionOptions.LockRead) == FbTransactionOptions.LockRead)
{
tpb.Append(IscCodes.isc_tpb_lock_read);
}
if ((options & FbTransactionOptions.LockWrite) == FbTransactionOptions.LockWrite)
{
tpb.Append(IscCodes.isc_tpb_lock_write);
}
if ((options & FbTransactionOptions.ReadCommitted) == FbTransactionOptions.ReadCommitted)
{
tpb.Append(IscCodes.isc_tpb_read_committed);
}
if ((options & FbTransactionOptions.Autocommit) == FbTransactionOptions.Autocommit)
{
tpb.Append(IscCodes.isc_tpb_autocommit);
}
if ((options & FbTransactionOptions.RecVersion) == FbTransactionOptions.RecVersion)
{
tpb.Append(IscCodes.isc_tpb_rec_version);
}
if ((options & FbTransactionOptions.NoRecVersion) == FbTransactionOptions.NoRecVersion)
{
tpb.Append(IscCodes.isc_tpb_no_rec_version);
}
if ((options & FbTransactionOptions.RestartRequests) == FbTransactionOptions.RestartRequests)
{
tpb.Append(IscCodes.isc_tpb_restart_requests);
}
if ((options & FbTransactionOptions.NoAutoUndo) == FbTransactionOptions.NoAutoUndo)
{
tpb.Append(IscCodes.isc_tpb_no_auto_undo);
}
return(tpb);
}
private TransactionParameterBuffer BuildTpb(FbTransactionOptions options)
{
TransactionParameterBuffer tpb = new TransactionParameterBuffer();
tpb.Append(IscCodes.isc_tpb_version3);
FbTransactionOptions[] o = (FbTransactionOptions[])Enum.GetValues(options.GetType());
for (int i = 0; i < o.Length; i++)
{
FbTransactionOptions option = ((FbTransactionOptions)(o[i]));
if ((options & option) == option)
{
switch (option)
{
case FbTransactionOptions.Consistency:
tpb.Append(IscCodes.isc_tpb_consistency);
break;
case FbTransactionOptions.Concurrency:
tpb.Append(IscCodes.isc_tpb_concurrency);
break;
case FbTransactionOptions.Shared:
tpb.Append(IscCodes.isc_tpb_shared);
break;
case FbTransactionOptions.Protected:
tpb.Append(IscCodes.isc_tpb_protected);
break;
case FbTransactionOptions.Exclusive:
tpb.Append(IscCodes.isc_tpb_exclusive);
break;
case FbTransactionOptions.Wait:
tpb.Append(IscCodes.isc_tpb_wait);
break;
case FbTransactionOptions.NoWait:
tpb.Append(IscCodes.isc_tpb_nowait);
break;
case FbTransactionOptions.Read:
tpb.Append(IscCodes.isc_tpb_read);
break;
case FbTransactionOptions.Write:
tpb.Append(IscCodes.isc_tpb_write);
break;
case FbTransactionOptions.LockRead:
tpb.Append(IscCodes.isc_tpb_lock_read);
break;
case FbTransactionOptions.LockWrite:
tpb.Append(IscCodes.isc_tpb_lock_write);
break;
case FbTransactionOptions.ReadCommitted:
tpb.Append(IscCodes.isc_tpb_read_committed);
break;
case FbTransactionOptions.Autocommit:
tpb.Append(IscCodes.isc_tpb_autocommit);
break;
case FbTransactionOptions.RecVersion:
tpb.Append(IscCodes.isc_tpb_rec_version);
break;
case FbTransactionOptions.NoRecVersion:
tpb.Append(IscCodes.isc_tpb_no_rec_version);
break;
case FbTransactionOptions.RestartRequests:
tpb.Append(IscCodes.isc_tpb_restart_requests);
break;
case FbTransactionOptions.NoAutoUndo:
tpb.Append(IscCodes.isc_tpb_no_auto_undo);
break;
}
}
}
return(tpb);
}
