private static void IncreaseBookCopies(BookShopContext context) { DateTime date = new DateTime(2013, 6, 6); var affectedBooks = context.Books.Update(b => b.ReleaseDate != null && b.ReleaseDate > date, b => new Book() { Copies = b.Copies + 44 }); Console.WriteLine($"{affectedBooks} books are released after 6 Jun 2013 so total of {affectedBooks*44} book copies were added"); context.SaveChanges(); }
private static void RemoveBooks(BookShopContext context) { var books = context.Books.Where(b => b.Copies < 4200); Console.WriteLine($"{books.Count()} books were deleted"); foreach (var b in books) { context.Books.Remove(b); } context.SaveChanges(); }
private static void RemoveBooks(BookShopContext context) { Console.WriteLine("Solution to Problem 14. Remove Books with copies < 4200"); var booksToRemove = context.Books.Where(b => b.Copies < 4200); Console.WriteLine($"{booksToRemove.Count()} books were deleted"); booksToRemove.Delete(); context.SaveChanges(); // Just a check //int remainingBooksCount = context.Books.Where(b => b.Copies < 4200).Count(); //Console.WriteLine($"Check: {remainingBooksCount} books with copies < 4200 remaining after Bulk Delete"); // 0 => all books are deleted Pause(); }
private static void IncreaseBookCopies(BookShopContext context) { string input = "06-06-2013"; DateTime date = DateTime.Parse(input); var books = context.Books.Where(b => b.ReleaseDate > date); int index = 0; foreach (var b in books) { b.Copies += 44; index++; } context.SaveChanges(); Console.WriteLine(index * 44); }
private static void IncreaseBookCopies(BookShopContext context) { Console.Write($"Please enter release date: "); string date = Console.ReadLine(); DateTime time = DateTime.ParseExact(date, "dd-MMM-yyyy", null); Console.Write($"Please enter number of copies: "); int numberOfCopies = int.Parse(Console.ReadLine()); var count = context.Books.Count(b => b.ReleaseDate > time); Console.WriteLine($"{count} books are released after {date} so total of {count * numberOfCopies} book copies were added"); var book = context.Books.Where(b => b.ReleaseDate > time); context.Books.Update(book, b => new Book() { Copies = b.Copies + numberOfCopies }); context.SaveChanges(); }
private static void IncreaseBookCopies(BookShopContext context) { Console.WriteLine("Solution to Problem 13. Increase Book Copies"); var booksToUpdate = context.Books.Where(b => b.ReleaseDate > new DateTime(2013, 6, 6)); int bookCopiesBeforeUpdate = booksToUpdate.Sum(b => b.Copies); booksToUpdate.Update(b => new Book() { Copies = b.Copies + 44 }); context.SaveChanges(); int bookCopiesAfterUpdate = booksToUpdate.Sum(b => b.Copies); Console.WriteLine($"{booksToUpdate.Count()} books are released after 6 Jun 2013 so total of {bookCopiesAfterUpdate - bookCopiesBeforeUpdate} book copies were added"); // actual number of added copies //Console.WriteLine($"{booksToUpdate.Count()} books are released after 6 Jun 2013 so total of {booksToUpdate.Count() * 44} book copies were added"); // calculated number of added copies after Bulk Update Pause(); }
private static void ShowFirstThreeRelatedBooks(BookShopContext 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.Take(3); foreach (var book in booksFromQuery) { Console.WriteLine($"--{book.Title}"); foreach (var relatedBook in book.RelatedBooks) { Console.WriteLine(relatedBook.Title); } } }
private static void SetRelatedBooks(BookShopContext context) { // Set Related Books List <Book> 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(); // Query Related Books books = context.Books.Take(3).ToList(); foreach (Book book in books) { Console.WriteLine($"--{book.Title}"); foreach (Book relatedBook in book.RelatedBooks) { Console.WriteLine(relatedBook.Title); } } }
static void Main() { var context = new BookShopContext(); //var migrationStrategy = new MigrateDatabaseToLatestVersion<BookShopContext, Configuration>(); //Database.SetInitializer(migrationStrategy); //Console.WriteLine(context.Books.Count()); 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.Take(3); // Query the first three books to get their names // and their related book names foreach (var book in booksFromQuery) { Console.WriteLine("--{0}", book.Title); foreach (var relatedBook in book.RelatedBooks) { Console.WriteLine(relatedBook.Title); } } //SeedAuthors(context); //Console.WriteLine(context.Authors.Count()); //SeedBooks(context); // //SeedCategories(context); //context.SaveChanges(); }
static void Main(string[] args) { var context = new BookShopContext(); context.SaveChanges(); }