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()));