We have MidLoad service on .NET Framework 4.8 and EntityFramework Core 3.1.32.
We use default Max Pool parameter in connection string for connect to MS SQL Server and all works fine.
But, when we try to upgrade the service to net 7 and efcore 7, after 2 hours of work, errors of exhaustion of the database connection pool begin to appear. We tried to make Max Pool = 500 and then the service worked for about 10 hours and errors appeared again. At the same time, SQL Server shows no more than 200 connections to the database at the peak. And at the current time everything works stably at Max Pool 100.
In the current version, we use our IdbContextFactory inside ActivatorUtilities.CreateInstance as well. In the new version, the standard IDbContextFactory
We have MidLoad service on .NET Framework 4.8 and EntityFramework Core 3.1.32.
We use default Max Pool parameter in connection string for connect to MS SQL Server and all works fine.
But, when we try to upgrade the service to net 7 and efcore 7, after 2 hours of work, errors of exhaustion of the database connection pool begin to appear. We tried to make Max Pool = 500 and then the service worked for about 10 hours and errors appeared again. At the same time, SQL Server shows no more than 200 connections to the database at the peak. And at the current time everything works stably at Max Pool 100.
In the current version, we use our IdbContextFactory inside ActivatorUtilities.CreateInstance as well. In the new version, the standard IDbContextFactory