public static List <Book> ListBooks() { using (Library2 lib = new Library2()) { var list = (from b in lib.Book select b).ToList(); return(list); } }
public static void DeleteBook(int bookId) { using (Library2 lib = new Library2()) { lib.Book.RemoveRange(from b in lib.Book where b.BookId == bookId select b); lib.SaveChanges(); Console.WriteLine($"Book no {bookId} has been deleted"); } }
static void Main(string[] args) { Library2 library = new Library2(); Database.InsertBook("rata", new Publisher(2), 1111, 11); Database.DeleteBook(39); List <Book> books = Database.ListBooks(); Database.PrintBooks(books); XMLSerializable.SaveAsXML("XMLFile.xml", books); SerializationJson.SaveAsJson("XMLFile.json", books); Console.ReadKey(); }
public static void InsertBook(string title, Publisher publisherId, int year, decimal price) { using (Library2 lib = new Library2()) { Book book = new Book() { Title = title, PublisherId = publisherId.PublisherId, Year = year, Price = price, }; if (book != null) { lib.Book.Add(book); lib.SaveChanges(); } Console.WriteLine($"Book no {book.BookId} has been inserted"); } }