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"));
}