示例#1
0
 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);
         }
     }
 }
示例#2
0
 protected override void OnShutdown()
 {
     DBAccessor.CloseConnection();
 }