protected HedgesController() { try { _dbContext = new FXWinV2Entities(true); //check Connection // _dbContext.Database.Connection.Open(); } catch (Exception exp) { _logger.Error(exp.Message); if (exp.InnerException != null) { _logger.Error(exp.InnerException.Message); } throw new HttpResponseException(new HttpResponseMessage(HttpStatusCode.InternalServerError) { Content = new StringContent(exp.Message), ReasonPhrase = "Critical error : " + exp.Message }); } finally { //_dbContext.Database.Connection.Close(); } }
public async Task <IHttpActionResult> CheckDbConnexion() { try { FXWinV2Entities _db = new FXWinV2Entities(); _db.Books.ToList(); return(Ok("Db connexion OK")); } catch (Exception exp) { throw new HttpResponseException(new HttpResponseMessage(HttpStatusCode.InternalServerError) { Content = new StringContent(exp.Message), ReasonPhrase = "Critical Exception : " + exp.Message }); } }