public static void AddUnreadCount() { using (DataContextWrapper <YapperDataContext> context = new DataContextWrapper <YapperDataContext>()) { var messages = (from message in context.Table <MessageModel>() where (message.MessageType == (long)MessageType.Conversation) orderby message.PostDateTimeUtcTicks descending select message); foreach (MessageModel message in messages) { message.UnreadCount = 0; } context.SubmitChanges(); } }
public static void AddIsTaskMessage() { using (DataContextWrapper <YapperDataContext> context = new DataContextWrapper <YapperDataContext>()) { var messages = (from message in context.Table <MessageModel>() where (message.MessageType != (long)MessageType.Conversation) orderby message.PostDateTimeUtcTicks descending select message); foreach (MessageModel message in messages) { message.IsTaskMessage = (message.MessageFlags & MessageFlags.Task) == MessageFlags.Task; } context.SubmitChanges(); } }