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);
