internal PersistenceDBAccessor(DbResourceAllocator dbResourceAllocator, Transaction transaction, WorkflowCommitWorkBatchService transactionService)
{
this.dbResourceAllocator = dbResourceAllocator;
this.localTransaction = DbResourceAllocator.GetLocalTransaction(transactionService, transaction);
this.connection = this.dbResourceAllocator.GetEnlistedConnection(transactionService, transaction, out this.needToCloseConnection);
this.dbRetry = new DbRetry(false);
}
internal PersistenceDBAccessor(DbResourceAllocator dbResourceAllocator, bool enableRetries)
{
this.dbResourceAllocator = dbResourceAllocator;
this.dbRetry = new DbRetry(enableRetries);
DbConnection connection = null;
short retryCount = 0;
Label_001D:
try
{
WorkflowTrace.Host.TraceEvent(TraceEventType.Information, 0, "SqlWorkflowPersistenceService OpenConnection start: " + DateTime.UtcNow.ToString("G", CultureInfo.InvariantCulture));
connection = this.dbResourceAllocator.OpenNewConnection();
WorkflowTrace.Host.TraceEvent(TraceEventType.Information, 0, "SqlWorkflowPersistenceService. OpenConnection end: " + DateTime.UtcNow.ToString("G", CultureInfo.InvariantCulture));
if ((connection == null) || (ConnectionState.Open != connection.State))
{
throw new InvalidOperationException(ExecutionStringManager.InvalidConnection);
}
}
catch (Exception exception)
{
WorkflowTrace.Host.TraceEvent(TraceEventType.Error, 0, "SqlWorkflowPersistenceService caught exception from OpenConnection: " + exception.ToString());
if (!this.dbRetry.TryDoRetry(ref retryCount))
{
throw;
}
WorkflowTrace.Host.TraceEvent(TraceEventType.Information, 0, "SqlWorkflowPersistenceService retrying.");
goto Label_001D;
}
this.connection = connection;
this.needToCloseConnection = true;
}
protected internal override void CommitWorkBatch(WorkflowCommitWorkBatchService.CommitWorkBatchCallback commitWorkBatchCallback)
{
DbRetry retry = new DbRetry(this._enableRetries);
short retryCount = 0;
Label_000E:
if (null != Transaction.Current)
{
retryCount = retry.MaxRetries;
}
try
{
base.CommitWorkBatch(commitWorkBatchCallback);
}
catch (Exception exception)
{
WorkflowTrace.Host.TraceEvent(TraceEventType.Error, 0, "DefaultWorkflowCommitWorkBatchService caught exception from commitWorkBatchCallback: " + exception.ToString());
if (!retry.TryDoRetry(ref retryCount))
{
throw;
}
WorkflowTrace.Host.TraceEvent(TraceEventType.Information, 0, "DefaultWorkflowCommitWorkBatchService retrying commitWorkBatchCallback (retry attempt " + retryCount.ToString(CultureInfo.InvariantCulture) + ")");
goto Label_000E;
}
}
/// <summary>
/// DB access done under a transaction and uses a connection enlisted to this transaction.
/// </summary>
/// <param name="dbResourceAllocator">Helper to get database connection/command/store procedure parameters/etc</param>
/// <param name="transaction">The transaction to do this work under</param>
internal PersistenceDBAccessor(
DbResourceAllocator dbResourceAllocator,
System.Transactions.Transaction transaction,
WorkflowCommitWorkBatchService transactionService)
{
this.dbResourceAllocator = dbResourceAllocator;
this.localTransaction = DbResourceAllocator.GetLocalTransaction(
transactionService, transaction);
// Get a connection enlisted to this transaction, may or may not need to be freed depending on
// if the transaction does connection sharing
this.connection = this.dbResourceAllocator.GetEnlistedConnection(
transactionService, transaction, out needToCloseConnection);
//
// No retries for external transactions
this.dbRetry = new DbRetry(false);
}
/// <summary>
/// DB access done without a transaction in a newly opened connection
/// </summary>
/// <param name="dbResourceAllocator">Helper to get database connection/command/store procedure parameters/etc</param>
internal PersistenceDBAccessor(DbResourceAllocator dbResourceAllocator, bool enableRetries)
{
this.dbResourceAllocator = dbResourceAllocator;
this.dbRetry = new DbRetry(enableRetries);
DbConnection conn = null;
short count = 0;
while (true)
{
try
{
WorkflowTrace.Host.TraceEvent(TraceEventType.Information, 0, "SqlWorkflowPersistenceService OpenConnection start: " + DateTime.UtcNow.ToString("G", System.Globalization.CultureInfo.InvariantCulture));
conn = this.dbResourceAllocator.OpenNewConnection();
WorkflowTrace.Host.TraceEvent(TraceEventType.Information, 0, "SqlWorkflowPersistenceService. OpenConnection end: " + DateTime.UtcNow.ToString("G", System.Globalization.CultureInfo.InvariantCulture));
if ((null == conn) || (ConnectionState.Open != conn.State))
throw new InvalidOperationException(ExecutionStringManager.InvalidConnection);
break;
}
catch (Exception e)
{
WorkflowTrace.Host.TraceEvent(TraceEventType.Error, 0, "SqlWorkflowPersistenceService caught exception from OpenConnection: " + e.ToString());
if (dbRetry.TryDoRetry(ref count))
{
WorkflowTrace.Host.TraceEvent(TraceEventType.Information, 0, "SqlWorkflowPersistenceService retrying.");
continue;
}
throw;
}
}
connection = conn;
needToCloseConnection = true;
}
protected internal override void CommitWorkBatch(WorkflowCommitWorkBatchService.CommitWorkBatchCallback commitWorkBatchCallback)
{
ManualResetEvent event2;
DbRetry retry = new DbRetry(this._enableRetries);
short maxRetries = retry.MaxRetries;
Label_0013:
event2 = new ManualResetEvent(false);
Transaction transaction = null;
SharedConnectionInfo connectionInfo = null;
try
{
if (null == Transaction.Current)
{
maxRetries = 0;
transaction = new CommittableTransaction();
connectionInfo = new SharedConnectionInfo(this.dbResourceAllocator, transaction, false, event2);
}
else
{
transaction = Transaction.Current.DependentClone(DependentCloneOption.BlockCommitUntilComplete);
connectionInfo = new SharedConnectionInfo(this.dbResourceAllocator, transaction, true, event2);
}
this.AddToConnectionInfoTable(transaction, connectionInfo);
using (TransactionScope scope = new TransactionScope(transaction))
{
try
{
commitWorkBatchCallback();
scope.Complete();
}
finally
{
this.RemoveConnectionFromInfoTable(transaction);
event2.Set();
}
}
CommittableTransaction transaction2 = transaction as CommittableTransaction;
if (transaction2 != null)
{
transaction2.Commit();
}
DependentTransaction transaction3 = transaction as DependentTransaction;
if (transaction3 != null)
{
transaction3.Complete();
}
}
catch (Exception exception)
{
transaction.Rollback();
WorkflowTrace.Host.TraceEvent(TraceEventType.Error, 0, "SharedConnectionWorkflowCommitWorkBatchService caught exception from commitWorkBatchCallback: " + exception.ToString());
if (!retry.TryDoRetry(ref maxRetries))
{
throw;
}
WorkflowTrace.Host.TraceEvent(TraceEventType.Information, 0, "SharedConnectionWorkflowCommitWorkBatchService retrying commitWorkBatchCallback (retry attempt " + maxRetries.ToString(CultureInfo.InvariantCulture) + ")");
goto Label_0013;
}
finally
{
event2.Close();
if (transaction != null)
{
transaction.Dispose();
}
}
}
