minipower-backend-healthcheck-dotnet-mssql

SQL Server

"HealthChecks": {
  "Readiness": {
    "SqlServer": "ConnectionStrings:MainDb"
  }
}

var keyPath = readiness.GetValue<string>("SqlServer");
var connectionString = configuration[keyPath!];

if (!string.IsNullOrWhiteSpace(connectionString))
{
    healthChecks.AddSqlServer(
        connectionString: connectionString,
        healthQuery: "SELECT 1;",
        name: "sqlserver",
        failureStatus: HealthStatus.Unhealthy,
        tags: [HealthCheckTags.Readiness],
        timeout: probeTimeout);
}