static void Main(string[] args) { var context = new BookShopDBContext(); context.Database.Initialize(true); var bookcount = context.Books.Count(); Console.WriteLine(bookcount); var books = context.Books.Take(3).ToList(); //Ruun the following lines ONLY once! Or it will print the books 2 times. //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("--{0}", book.Title); foreach (var relatedBook in book.RelatedBooks) { Console.WriteLine(relatedBook.Title); } Console.WriteLine(); } }
static void Main(string[] args) { var ctx = new BookShopDBContext(); var tran = ctx.Database.BeginTransaction(); var books = ctx.Books .Where(b => b.Copies < 4200) .ToList(); ctx.Books.RemoveRange(books); ctx.SaveChanges(); Console.WriteLine($"{books.Count} books were deleted"); tran.Rollback(); }
public void ChangeWebURL() { Console.Write("New Quantum Networking WebUrl > "); string newWebUrl = Console.ReadLine(); using (var db = new BookShopDBContext()) { Book singleBook = db.Books .Include(book => book.Author) .Single(book => book.Title == "Quantum Networking"); singleBook.Author.WebUrl = newWebUrl; db.SaveChanges(); Console.WriteLine("changes had been saved ..."); } ListAll(); }
public IActionResult Buy(Order order) { _context.Order.Add(order); _context.SaveChanges(); return(RedirectToAction("Success", "Your Order is successfull")); }