How to check connection to database in Entity Framework Core?

Question

In normal entity framework I am able to check the database connectivity using dbContext.Database.Exists() but in Entity Framework Core it is not there. What is the alternative of dbContext.Database.Exists() in Entity Framework Core?

Answer 1

You can determine whether or not the database is available and can be connected to with the CanConnect() method:

if (dbContext.Database.CanConnect())
{
    // all good
}

You can use CanConnectAsync() for asynchronous operation.