public static void MarkFolderAsReadCommand(this FeedsDbEntities context, Guid folderId, MarkOptions markOptions)
{
context.Database.ExecuteSqlCommand(@"
UPDATE Item
SET ReadDateTime = {0}
WHERE (Id IN
(SELECT Item_1.Id
FROM Item AS Item_1
INNER JOIN Feed ON Feed.Id = Item_1.FeedId
INNER JOIN Folder ON Folder.Id = Feed.FolderId
WHERE (Item_1.ReadDateTime IS NULL) AND (Folder.Id = {1})))",
DateTime.Now, folderId);
}
public void Mark(Guid id, MarkOptions markOptions)
{
_context.MarkFeedAsReadCommand(id, markOptions);
}
public static void MarkFeedAsReadCommand(this FeedsDbEntities context, Guid feedId, MarkOptions markOptions)
{
context.Database.ExecuteSqlCommand("UPDATE [Item] SET [ReadDateTime] = {0} WHERE [FeedId] = {1} AND [ReadDateTime] IS NULL",
DateTime.Now, feedId);
}
