EF Data Context – Async/Await & Multithreading

by

The DataContext class is part of LINQ to SQL. It does not understand async/await AFAIK, and should not be used with the Entity Framework async extension methods.

The DbContext class will work fine with async as long as you are using EF6 or higher; however, you can only have one operation (sync or async) per DbContext instance running at a time. If your code is actually using DbContext, then examine the call stack of your exception and check for any concurrent usage (e.g., Task.WhenAll).

If you are sure that all access is sequential, then please post a minimal repro and/or report it as a bug to Microsoft Connect.

More Related Contents:

  1. If async-await doesn’t create any additional threads, then how does it make applications responsive?
  2. Run async method regularly with specified interval
  3. Cancelling a pending task synchronously on the UI thread
  4. Async/Await vs Threads
  5. ConfigureAwait pushes the continuation to a pool thread
  6. How to get awaitable Thread.Sleep?
  7. Queue of async tasks with throttling which supports muti-threading
  8. Async thread body loop, It just works, but how?
  9. Parallel doesnt work with Entity Framework
  10. The lack of non-capturing Task.Yield forces me to use Task.Run, why follow that?
  11. Async and Await with For Loop [duplicate]
  12. Wrapping ManualResetEvent as awaitable task
  13. How and when to use ‘async’ and ‘await’
  14. Creating a blocking Queue in .NET?
  15. Question about terminating a thread cleanly in .NET
  16. Ignoring a class property in Entity Framework 4.1 Code First
  17. What is the difference between await Task and Task.Result?
  18. ‘using’ statement vs ‘try finally’
  19. Why is .Contains slow? Most efficient way to get multiple entities by primary key?
  20. Thread.Sleep for less than 1 millisecond
  21. Enforce an async method to be called once
  22. Entity Framework/Linq EXpression converting from string to int
  23. What is the use for Task.FromResult in C#
  24. STAThread and multithreading
  25. How to convert an expression tree to a partial SQL query?
  26. Enable Migrations with Context in Separate Assembly?
  27. How to achieve remove_if functionality in .NET ConcurrentDictionary
  28. How to compare only Date without Time in DateTime types?
  29. Set database timeout in Entity Framework
  30. Multithreaded NamePipeServer in C#

Leave a Comment