Example #1
0
 private void Timer_Job(object obj)
 {
     try
     {
         var databases = databasesRepository.GetAll();
         foreach (var d in databases)
         {
             try
             {
                 using (var scope = new DatabaseScope(d.Name))
                 {
                     var data = builder.Build();
                     data.StoredProcedures.IntersectWith(data.StoredProcedures.Where(x => ContainsView(x)));
                     data.Views.IntersectWith(data.Views.Where(x => ContainsView(x)));
                     dependencyHierarchyFilteredForViewPerDatabase.AddOrUpdate(d.ID, data, (k, v) => data);
                 }
             }
             catch (Exception ex)
             {
                 log.Write(ex);
             }
         }
     }
     catch (Exception ex)
     {
         log.Write(ex);
     }
 }