AddDbContext or AddDbContextPool

by

The answer is here (under “DbContext pooling”): https://learn.microsoft.com/en-us/ef/core/what-is-new/ef-core-2.0#dbcontext-pooling

DbContext is not thread-safe. So you cannot reuse the same DbContext object for multiple queries at the same time (weird things happen). The usual solution for this has been to just create a new DbContext object each time you need one. That’s what AddDbContext does.

However, there is nothing wrong with reusing a DbContext object after a previous query has already completed. That’s what AddDbContextPool does. It keeps multiple DbContext objects alive and gives you an unused one rather than creating a new one each time.

Which one you use is up to you. Both will work. Pooling has some performance gains. However the documentation warns that if you use any private properties in your DbContext class that should not be shared between queries, then you should not use it. I imagine that’s pretty rare though, so pooling should be appropriate in most cases.

More Related Contents:

  1. How to run stored procedures in Entity Framework Core?
  2. Entity Framework Core service default lifetime
  3. why remove-migration run my app?
  4. Unable to create migrations after upgrading to ASP.NET Core 2.0
  5. Google JWT Authentication with AspNet Core 2.0
  6. How to update the model when using database first approach
  7. Entity Framework Core: DbContextOptionsBuilder does not contain a definition for ‘usesqlserver’ and no extension method ‘usesqlserver’
  8. Store / Retrieve ConnectionString from appSettings.json in ASP.net Core 2 MVC app
  9. Dynamically change connection string in Asp.Net Core
  10. Where are the Login and Register pages in an AspNet Core scaffolded app?
  11. Dynamically changing schema in Entity Framework Core
  12. Equivalent for .HasOptional in Entity Framework Core 1 (EF7)
  13. How do I setup multiple auth schemes in ASP.NET Core 2.0?
  14. .NET Core vs ASP.NET Core
  15. How to set redirect_uri protocol to HTTPS in Azure Web Apps
  16. ASP.NET Core change EF connection string when user logs in
  17. Using EF Core ThenInclude() on Junction tables
  18. Unable to edit db entries using EFCore, EntityState.Modified: “Database operation expected to affect 1 row(s) but actually affected 0 row(s).”
  19. .Net Core on Raspberry Pi 4 with Raspbian?
  20. Add migration with different assembly
  21. Tag helper not being processed in ASP.NET Core 2
  22. Multipart body length limit exceeded exception
  23. How to watch for file changes “dotnet watch” with Visual Studio ASP.NET Core
  24. ‘HttpPostedFileBase’ in Asp.Net Core 2.0
  25. Get a service in a IServiceCollection extension
  26. Implementing recursive property loading in EF Core
  27. Run database migrations using Entity Framework core on application start
  28. How to resolve .net core build error NETDSDK1061 and warning MSB3277
  29. ASP .NET Core default language is always English
  30. Disable chunking in ASP.NET Core

Leave a Comment