static void Main(string[] args) { ServicesConfiguration.ReadJson(); ServicesConfiguration.MongoConfiguration(); ServicesConfiguration.SqlServerConfiguration(); IList <DiarySettingsPeriodDTO> diary = new List <DiarySettingsPeriodDTO>(); DiarySettingsPeriodDTO document; var mongoSettings = new SettingsRepository(); var Sqlclasses = new ClassRepository(); // Find All Documents in this Collection .... var mongoFindAll = mongoSettings.FindAll(); //var mongoFindAll = mongoSettings.FindAllTeste(); foreach (var findAll in mongoFindAll) { int school = findAll.School; IList <ClassDTO> GetClassByIdSchool = Sqlclasses.GetClassByIdSchool(school); var CountMorning = GetClassByIdSchool.Count(x => x.ShiftTypeId == 1); var CountEvening = GetClassByIdSchool.Count(x => x.ShiftTypeId == 2); var CountIntegral = GetClassByIdSchool.Count(x => x.ShiftTypeId == 4); document = new DiarySettingsPeriodDTO(); document.School = findAll.School; document.IsGuarianAllowedToSendMessage = findAll.IsGuarianAllowedToSendMessage; if (CountMorning > 0) { ExistMorning(document, findAll); } else { DoesNotExistMorning(document, findAll); } if (CountEvening > 0) { ExistEvening(document, findAll); } else { DoesNotExistEvening(document, findAll); } if (CountIntegral > 0) { ExistIntegral(document, findAll); } else { DoesNotExistIntegral(document, findAll); } diary.Add(document); var deletedFilter = mongoFindAll.Select(d => d.School); mongoSettings.DeletedAll(deletedFilter); //mongoSettings.DeletedAllTeste(deletedFilter); } //var trying = mongoSettings.FindAllTeste(); var trying = mongoSettings.FindAll(); foreach (var list in diary) { mongoSettings.InsertOne(list); } }