About This is a complete project to creating ASP.NET Core Web API using .NET8, Entity Framework Core (EF Core), and SQL Server database.

General question:We recently switched one of our applications to Application Role security, which mandates (because the backend is SQL2000) that we turn off .NET Connection pooling for the sql ...

Take advantage of the open source library Serilog to log your ASP.NET Core application’s data to SQL Server or another database target.

Use custom-built .NET Framework 4.0 classes to connect an ASP.NET Web application to a SQL Server 2012 database.

I think I fixed the issue in its entirety by setting the connection timeout time to 40 seconds. This is a strong indication that my hosting provider is overloading there shared sql server resource.