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
});
}
}
