private void CleanDatabase(Schedule schedule) { // connect to the database DatabaseDataContext db = new DatabaseDataContext(); // delete last 50 records for this schedule from the database List<Information> toDelete = new List<Information>(); foreach (Information i in db.Informations.Where(z => z.ScheduleID == schedule.ID && db.Informations.Where(y => y.ScheduleID == schedule.ID).OrderByDescending(y => y.CreatedDate).Take(100).Contains(z) == false)) { toDelete.Add(i); } // delete information from database db.Informations.DeleteAllOnSubmit(toDelete); db.SubmitChanges(); // close connection db.Dispose(); }
public Job(Schedule schedule) { Schedule = schedule; }
partial void UpdateSchedule(Schedule instance);
partial void DeleteSchedule(Schedule instance);
partial void InsertSchedule(Schedule instance);