protected virtual void KeepSQLConnectionAlive() { try { DBAccessor.Database.Execute("DO 1"); } catch (Exception ex) { logger.Error("Cannot ping SQL connection : {0}", ex); logger.Warn("Try to Re-open the connection"); try { DBAccessor.CloseConnection(); DBAccessor.OpenConnection(); } catch (Exception ex2) { logger.Error("Cannot reopen the SQL connection : {0}", ex2); } } }
protected override void OnShutdown() { DBAccessor.CloseConnection(); }