private static void IncreaseBookCopies(BookShopLabContext context) { Console.WriteLine("Please enter a date:"); DateTime date = DateTime.Parse(Console.ReadLine()); Console.WriteLine("Please enter book copies (int):"); int bookCopies = int.Parse(Console.ReadLine()); var books = context.Books .Where(b => b.ReleaseDate > date); Console.WriteLine("Result: "); Console.WriteLine(books.Count() * bookCopies); var updatedBooks = context.Books .Where(b => b.ReleaseDate > date) .Update(b => new Book() { Copies = b.Copies + bookCopies }); Console.WriteLine("Updated Books: {0}", updatedBooks); context.SaveChanges(); }
private static void GetRelatedBooks(BookShopLabContext context) { var books = context.Books .Take(3) .ToList(); books[0].RelatedBooks.Add(books[1]); books[1].RelatedBooks.Add(books[0]); books[0].RelatedBooks.Add(books[2]); books[2].RelatedBooks.Add(books[0]); context.SaveChanges(); var booksFromQuery = context.Books .Select(b => new { b.Title, relatedBooks = b.RelatedBooks }) .Take(3); foreach (var book in booksFromQuery) { Console.WriteLine("--{0}", book.Title); foreach (var b in book.relatedBooks) { Console.WriteLine(b.Title); } } }
private static void RemoveBooks(BookShopLabContext context) { Console.WriteLine("Please enter number (int):"); int number = int.Parse(Console.ReadLine()); var books = context.Books .Where(b => b.Copies < number) .Delete(); Console.WriteLine($"Deleted books: {books}"); context.SaveChanges(); }