public async Task <IActionResult> DeleteAllStudents() { using (var connection = new SqlConnection(Configuration.GetConnectionString("DefaultConnection"))) { try { connection.Open(); var numberOfAffectedRows = await StudentsRepository.DeleteAllStudentsAsync(connection); if (numberOfAffectedRows == 0) { return(NotFound("There aren't any students in database")); } } catch (Exception ex) { return(BadRequest(ex.Message)); } } return(NoContent()); }