private IEnumerable <Message> FetchMessagesFromDb() { using (testDBEntities db = new testDBEntities()) { // return db.Messages.Where(lm => lm.IsSent == false).ToList(); return(db.Messages.Where(im => im.IsSent == false || im.IsSent == true).ToList()); } }
internal void NewMessageRecieved(object sender, SqlNotificationEventArgs e) { IEnumerable <Message> newMessages = FetchMessagesFromDb(); _dispatcher(newMessages.Select(lm => lm.MessageText)); using (testDBEntities db = new testDBEntities()) { //Mark all dispatched messages as sent newMessages.ToList().ForEach(lm => { db.Messages.Attach(lm); lm.IsSent = true; }); db.SaveChanges(); } }