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