Test (Check) SQL Database connection from Controller in ASP.Net Core MVC

Hi sunkana,

Refer below code.

Controller

public class HomeController : Controller
{
    public IActionResult Index()
    {
        ConnectionStatus connectionStatus = IsServerConnected(@"Server=.\SQL2014;DataBase=Test;UID=sa;PWD=pass@123");
        if (connectionStatus.Status)
        {
            // Success.
            ViewData["Message"] = connectionStatus.Message;
        }
        else
        {
            // Fail.
            ViewData["Message"] = connectionStatus.Message;
        }
        return View();
    }

    public ConnectionStatus IsServerConnected(string connectionString)
    {
        ConnectionStatus status = new ConnectionStatus();
        using (SqlConnection connection = new SqlConnection(connectionString))
        {
            try
            {
                connection.Open();
                status.Status = true;
                status.Message = "Success";
                return status;
            }
            catch (SqlException ex)
            {
                status.Status = false;
                status.Message = "Failed";
                if (ex.Number == -2)
                {
                    status.Message = "Failure not accessible";
                }
                return status;
            }
        }
    }

    public class ConnectionStatus
    {
        public string Message { get; set; }
        public bool Status { get; set; }
    }
}

View

@if (ViewData["Message"] != null)
{
    <span>Connection : @ViewData["Message"]</span>
}

Screenshot