Does Entity Framework support parallel async queries? [duplicate]

by

This is not supported as per the specifications of version 6.

This should throw a DbConcurrencyException exception saying

A second operation started on this context before a previous
asynchronous operation completed. Use ‘await’ to ensure that any
asynchronous operations have completed before calling another method
on this context. Any instance members are not guaranteed to be thread
safe.

EF will detect if the developer attempts to execute two async operations at one time and throw.

From a codeplex page of the project:

Enabling asynchronous execution of database operations is actually
orthogonal to enabling concurrent execution on the same context. In
the particular case of server scenarios, using concurrent access could
affect scalability negatively as it would mean that in order to
process a single request you would be spinning of an arbitrary number
of different threads. All the threads would compete for resources such
as memory with other threads necessary to server other concurrent
requests.

Entity Framework Core does not support this scenario either.

EF Core doesn’t support multiple parallel operations being run on the same context instance. You should always wait for an operation to complete before beginning the next operation. This is typically done by using the await keyword on each async operation.

More Related Contents:

  1. How can I configure Entity Framework to automatically trim values retrieved for specific columns mapped to char(N) fields?
  2. Introducing FOREIGN KEY constraint may cause cycles or multiple cascade paths – why?
  3. Like Operator in Entity Framework?
  4. How can I query for null values in entity framework?
  5. .NET Entity Framework and transactions
  6. Get Database Table Name from Entity Framework MetaData
  7. Can you use Microsoft Entity Framework with Oracle? [closed]
  8. “Items collection must be empty before using ItemsSource.”
  9. Undo changes in entity framework entities
  10. Update primary key value using entity framework
  11. ASP.NET MVC: Is Controller created for every request?
  12. EF LINQ include multiple and nested entities
  13. Cannot attach the file *.mdf as database
  14. Is is possible to check if an object is already attached to a data context in Entity Framework?
  15. Generate POCO classes in different project to the project with Entity Framework model
  16. How to work with Enums in Entity Framework?
  17. What are Navigation Properties in Entity Framework for?
  18. LINQ to Entities does not recognize the method Int32 get_Item(Int32)
  19. How to set default value for POCO’s in EF CF?
  20. How to map table splitting in EF Code First?
  21. Organizationally, where should I put common queries when using Entity Framework Code First?
  22. Entity Framework 4 Single() vs First() vs FirstOrDefault()
  23. Using entity framework on multiple databases
  24. entity framework Unable to load the specified metadata resource [duplicate]
  25. The model backing the ‘ApplicationDbContext’ context has changed since the database was created
  26. Entity Framework Find vs. Where
  27. Do you think it’s advantageous to switch to Entity Framework? [closed]
  28. ‘ObjectContext’ vs ‘DbContext’ in Entity Framework
  29. Using Entity Framework entities as business objects?
  30. How can set a default value constraint with Entity Framework 6 Code First?

Leave a Comment