private void UpdateDatabase() { using (EmailImportDataContext dc = new EmailImportDataContext()) { var email = dc.Emails.Where(em => em.EmailID == Email.EmailID).FirstOrDefault(); if (email != null) { email.Errors = Email.Errors; dc.SubmitChanges(); } } }
private int ReprocessEmails(IEnumerable <Email> emails) { var emailIDs = emails.Select(e => e.EmailID); int n = 0; using (EmailImportDataContext dc = new EmailImportDataContext()) { var reprocessEmails = dc.Emails.Where(e => emailIDs.Contains(e.EmailID)); foreach (var email in reprocessEmails) { if (email.Status != null) { email.Status = null; n++; } } dc.SubmitChanges(); } return(n); }