private void RemoveStreamChatFromDb(long streamId) { using (var context = new ChatDataContext()) { var existingChat = context.Chats.Where(item => item.streamId == streamId); context.RemoveRange(existingChat); context.SaveChanges(); } }
// removes any in-progress live stream downloads since the last run from the database public Task RemoveLeftOverLiveStreamDownloads() { List <Stream> streams; Console.WriteLine("Checking for dead streams..."); using (var mainDataContext = new MainDataContext()) { streams = mainDataContext.Streams.Where(stream => stream.vodId != 0 && stream.downloading).ToList(); mainDataContext.RemoveRange(streams); if (streams.Count > 0) { using (var chatDataContext = new ChatDataContext()) { chatDataContext.RemoveRange(chatDataContext.Chats.Where(chat => streams.Select(stream => stream.streamId).Contains(chat.streamId))); chatDataContext.SaveChanges(); } } mainDataContext.SaveChanges(); } Console.WriteLine("Done!"); return(Task.CompletedTask); }