Connection Resiliency in ASP.NET Core
Enable retry logic for transient failures by configuring connection resiliency.
services.AddDbContext<ApplicationDbContext>(options => options.UseSqlServer(Configuration.GetConnectionString("DefaultConnection"), sqlServerOptions => sqlServerOptions.EnableRetryOnFailure()));