Get TransactionScope to work with async / await

by

In .NET Framework 4.5.1, there is a set of new constructors for TransactionScope that take a TransactionScopeAsyncFlowOption parameter.

According to the MSDN, it enables transaction flow across thread continuations.

My understanding is that it is meant to allow you to write code like this:

// transaction scope
using (var scope = new TransactionScope(... ,
  TransactionScopeAsyncFlowOption.Enabled))
{
  // connection
  using (var connection = new SqlConnection(_connectionString))
  {
    // open connection asynchronously
    await connection.OpenAsync();

    using (var command = connection.CreateCommand())
    {
      command.CommandText = ...;

      // run command asynchronously
      using (var dataReader = await command.ExecuteReaderAsync())
      {
        while (dataReader.Read())
        {
          ...
        }
      }
    }
  }
  scope.Complete();
}

More Related Contents:

  1. An async/await example that causes a deadlock
  2. Can constructors be async?
  3. If async-await doesn’t create any additional threads, then how does it make applications responsive?
  4. Await on a completed task same as task.Result?
  5. Using async-await on .net 4
  6. Async/await with/without awaiting (fire and forget)
  7. Call asynchronous method in constructor?
  8. Why should I prefer single ‘await Task.WhenAll’ over multiple awaits?
  9. I want await to throw AggregateException, not just the first Exception
  10. When should I use Async Controllers in ASP.NET MVC?
  11. Is Task.Run considered bad practice in an ASP .NET MVC Web Application?
  12. Synchronously waiting for an async operation, and why does Wait() freeze the program here
  13. Await operator can only be used within an Async method [duplicate]
  14. EF Data Context – Async/Await & Multithreading
  15. Download multiple files async and wait for all of them to finish before executing the rest of the code
  16. Why was “SwitchTo” removed from Async CTP / Release?
  17. How does TransactionScope roll back transactions?
  18. Task.Factory.StartNew with async lambda and Task.WaitAll
  19. C# async/await Progress event on Task object
  20. MoveNext instead of actual method/task name
  21. How do you create an asynchronous method in C#?
  22. Effectively use async/await with ASP.NET Web API
  23. Cannot implicitly convert type from Task
  24. Correct way to use HttpContext.Current.User with async await
  25. Faulted vs Canceled task status after CancellationToken.ThrowIfCancellationRequested
  26. Non-Generic TaskCompletionSource or alternative
  27. How do I get a return value from Task.WaitAll() in a console app?
  28. call async method without await #2
  29. Intercept async method that returns generic Task via DynamicProxy
  30. Wrapping ManualResetEvent as awaitable task

Leave a Comment