DbContextHealthCheck.cs

public class DbContextHealthCheck : IHealthCheck
    {
        private readonly Func<string, DataContext> _dbContext;

        private readonly List<ConsolidatorSettings> _consolidatorSettings;

        public DbContextHealthCheck(Func<string, DataContext> dbContext, IOptions<List<ConsolidatorSettings>> consolidatorSettings)
        {
            _dbContext = dbContext;
            _consolidatorSettings = consolidatorSettings.Value;
        }

        public async Task<HealthCheckResult> CheckHealthAsync(HealthCheckContext context, CancellationToken cancellationToken = default)
        {
            try
            {
                foreach (var consolidator in _consolidatorSettings)
                {
                    var connected = await _dbContext(consolidator.Name).Database.CanConnectAsync(cancellationToken).ConfigureAwait(false);

                    if (!connected)
                        return HealthCheckResult.Unhealthy("Unhealthy");
                }

                return HealthCheckResult.Healthy("Healthy");
            }
            catch (Exception ex)
            {
                return HealthCheckResult.Unhealthy("Unhealthy", ex);
            }
        }
    }