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