static void Main(string[] args)
{
var connection = ConnectionManager.GetConnection();
/*2.Create a new console app named SummaryPublisherApp.Here print to console:
* Number of rows from the Publisher table(Execute scalar) ===> not done
* Top 10 publishers(Id, Name)(SQL Data Reader)*/
PublisherRepository.getTopTen(connection);
/*Number of books for each publisher (Publiher Name, Number of Books)*/
PublisherRepository.NumberOfBooks(connection);
/*The total price for books for a publisher*/
PublisherRepository.BookCosts(connection);
/*3. Number of books and publisher name ( Create a class NumberOfBooksPerPublisher { NoOfBooks, PublisherName }, load the information into a List<NumberOfBooksPerPublisher > )*/
List <NumberOfBooksPerPublisher> List = new List <NumberOfBooksPerPublisher>();
var NewList = PublisherRepository.NumberOfBooks(connection);
PublisherRepository.getTopTen(connection);
/*4. Load data from a table (author, books, etc.) into a list (List<Book> or List<Author) and serialize all lines from that table in xml and json into two files.
* Example: books.xml and books.json*/
/*a. books.xml serialisation - Nu cred ca am facut bine deloc*/
List <Book> Book = new List <Book>();
Book = BookRepository.LoadBook(connection);
var book = SerializeObject(Book);
}
