static void Main(string[] args)
{
IPublisherRepository pub = new PublisherRepository();
Console.WriteLine($"Number of rows from the Publisher table {pub.NrOfRowsFromPublisher()}");
Console.WriteLine();
Console.WriteLine("Top 10 publishers");
foreach (var top10Publisher in pub.GetTop10Publishers())
{
Console.WriteLine($"{top10Publisher.PublisherId} {top10Publisher.Name}");
}
Console.WriteLine();
Console.WriteLine("Number of books for each publisher (Publiher Name, Number of Books)");
foreach (var x in pub.AllBooksForEachPublisher())
{
Console.WriteLine($"{x.PublisherName} {x.NoOfBooks}");
}
Console.WriteLine();
Console.WriteLine($"The total price for books for a publisher");
Console.WriteLine($"Number of books and publisher name ( Create a class NumberOfBooksPerPublisher , load the information into a List<NumberOfBooksPerPublisher > )");
foreach (var z in pub.TotalPriceForAllBooksForEachPublisher())
{
Console.WriteLine($"{z.PublisherName} {z.TotalPrice}");
}
}
