Verifying database connectivity is crucial for application reliability and user experience. This post outlines two approaches to test database availability with EF Core: using the CanConnectAsync() method for application-level checks and the DbContext check with ASP.NET Core health checks framework for infrastructure-level monitoring. It also includes setup instructions for using a SQL Server Test Container and Docker.
Table of contents
Prerequisites for Running the Database Connectivity ChecksUsing CanConnectAsync for Database Connectivity ChecksUsing HealthChecks for Infrastructure-Level Checks and Container OrchestratorsConclusionSort: