ASP.NET Core DbContext Health Check

DatabaseHealthCheck.cs

using System.Threading;
using System.Threading.Tasks;
using Microsoft.Extensions.Diagnostics.HealthChecks;
using Microsoft.Extensions.Logging;

namespace Common.Api.HealthCheck
{
	public class DatabaseHealthCheck<TDbContext> : IHealthCheck where TDbContext : DbContext
	{
		private readonly ILogger _logger;
		private readonly TDbContext _context;

		public DatabaseHealthCheck(TDbContext context, ILogger<DatabaseHealthCheck<TDbContext>> logger)
		{
			_context = context;
			_logger = logger;
		}

		public async Task<HealthCheckResult> CheckHealthAsync(
			HealthCheckContext context,
			CancellationToken cancellationToken = new CancellationToken())
		{
			var database = _context.Database;
			await database.ExecuteSqlInterpolatedAsync($"select 1", cancellationToken);

			if (await database.CanConnectAsync(cancellationToken))
				return HealthCheckResult.Healthy("Database is operating normally.");
			
			return HealthCheckResult.Unhealthy("Cannot connect to database");
		}
	}
}