示例#1
0
        public void GetAllAuthors()
        {
            var authors = new List <Author>();

            using (var db = new LibraryDBContext())
            {
                foreach (var author in db.Author)
                {
                    Console.WriteLine("Name: {0} {1}    " + "Country: {2}    " + "Number of Books: {3}    " + "\n", author.AuthorName, author.Surname, author.Country, author.Book.Count);
                }
            }
        }
示例#2
0
        public void FindBooks(string surname)
        {
            using (var db = new LibraryDBContext())
            {
                Author author = db.Author.FirstOrDefault(a => a.Surname == surname);

                if (author != null)
                {
                    var books = author.Book;

                    foreach (var book in books)
                    {
                        Console.WriteLine("{0}, {1}", book.BookName, book.Year);
                    }
                }
                else
                {
                    Console.WriteLine("This author has no books");
                }
            }
        }
示例#3
0
        public void InsertData()
        {
            var StephenKing = new Author
            {
                AuthorName = "Stephen",
                Surname    = "King",
                Country    = "USA"
            };
            var kingsBooks = new List <Book>
            {
                new Book {
                    BookName = "Carrie", Year = 1974, Author = StephenKing
                },
                new Book {
                    BookName = "The Shining", Year = 1977, Author = StephenKing
                },
                new Book {
                    BookName = "Insomnia", Year = 1994, Author = StephenKing
                },
                new Book {
                    BookName = "The Green Mile", Year = 1996, Author = StephenKing
                },
                new Book {
                    BookName = "11/22/63", Year = 2011, Author = StephenKing
                },
                new Book {
                    BookName = "Mr. Mercedes", Year = 2014, Author = StephenKing
                },
                new Book {
                    BookName = "Revival", Year = 2014, Author = StephenKing
                },
                new Book {
                    BookName = "Elevation", Year = 2018, Author = StephenKing
                }
            };

            StephenKing.Book = kingsBooks;

            var JoanneRowling = new Author
            {
                AuthorName = "Joanne",
                Surname    = "Rowling",
                Country    = "Great Britain",
            };
            var rowlingsBooks = new List <Book>
            {
                new Book {
                    BookName = "Harry Potter and the Philosopher's Stone", Year = 1997, Author = JoanneRowling
                },
                new Book {
                    BookName = "Harry Potter and the Chamber of Secrets", Year = 1998, Author = JoanneRowling
                },
                new Book {
                    BookName = "Harry Potter and the Prisoner of Azkaban", Year = 1999, Author = JoanneRowling
                },
                new Book {
                    BookName = "Harry Potter and the Goblet of Fire", Year = 2000, Author = JoanneRowling
                },
                new Book {
                    BookName = "Harry Potter and the Order of the Phoenix ", Year = 2003, Author = JoanneRowling
                },
                new Book {
                    BookName = "Harry Potter and the Half-Blood Prince", Year = 2005, Author = JoanneRowling
                },
                new Book {
                    BookName = "Harry Potter and the Deathly Hallows", Year = 2007, Author = JoanneRowling
                }
            };

            JoanneRowling.Book = rowlingsBooks;

            var AlexandreDumas = new Author
            {
                AuthorName = "Alexandre",
                Surname    = "Dumas",
                Country    = "France"
            };
            var dumasBooks = new List <Book>
            {
                new Book {
                    BookName = "Vingt Ans Apres", Year = 1845, Author = AlexandreDumas
                },
                new Book {
                    BookName = " The Count Of Monte Cristo", Year = 1846, Author = AlexandreDumas
                },
                new Book {
                    BookName = " The Queen's Necklace", Year = 1850, Author = AlexandreDumas
                },
                new Book {
                    BookName = "The Black Tulip ", Year = 1850, Author = AlexandreDumas
                },
            };

            AlexandreDumas.Book = dumasBooks;

            var JulesVerne = new Author
            {
                AuthorName = "Jules Gabriel",
                Surname    = "Verne",
                Country    = "France"
            };
            var vernesBooks = new List <Book>
            {
                new Book {
                    BookName = "20,000 Leagues Under the Sea", Year = 2018, Author = JulesVerne
                },
                new Book {
                    BookName = "From the Earth to the Moon; And, Round the Moon", Year = 2016, Author = JulesVerne
                },
                new Book {
                    BookName = "The Jules Verne Anthology", Year = 2014, Author = JulesVerne
                },
                new Book {
                    BookName = "The Exploration of the World", Year = 2014, Author = JulesVerne
                },
            };

            JulesVerne.Book = vernesBooks;

            var HarukiMurakami = new Author
            {
                AuthorName = "Haruki",
                Surname    = "Murakami",
                Country    = "Japan"
            };
            var murakamisBooks = new List <Book>
            {
                new Book {
                    BookName = "Hear the Wind Sing", Year = 2015, Author = HarukiMurakami
                },
                new Book {
                    BookName = "A Wild Sheep Chase", Year = 1989, Author = HarukiMurakami
                },
                new Book {
                    BookName = "Norwegian Wood", Year = 1989, Author = HarukiMurakami
                },
                new Book {
                    BookName = "After Dark", Year = 2007, Author = HarukiMurakami
                },
                new Book {
                    BookName = "1Q84", Year = 2011, Author = HarukiMurakami
                },
                new Book {
                    BookName = "The Elephant Vanishes", Year = 1993, Author = HarukiMurakami
                },
                new Book {
                    BookName = "Killing Commendatore", Year = 2018, Author = HarukiMurakami
                },
                new Book {
                    BookName = "Men Without Women", Year = 2017, Author = HarukiMurakami
                },
                new Book {
                    BookName = "Underground", Year = 2000, Author = HarukiMurakami
                }
            };

            HarukiMurakami.Book = murakamisBooks;

            using (var db = new LibraryDBContext())
            {
                db.Author.Add(StephenKing);
                db.Author.Add(JoanneRowling);
                db.Author.Add(JulesVerne);
                db.Author.Add(HarukiMurakami);
                db.Author.Add(AlexandreDumas);

                db.Book.AddRange(kingsBooks);
                db.Book.AddRange(rowlingsBooks);
                db.Book.AddRange(dumasBooks);
                db.Book.AddRange(vernesBooks);
                db.Book.AddRange(murakamisBooks);

                db.SaveChanges();
            }

            #region

            /*var authors = new List<Author>()
             * {
             *  new Author
             *  {
             *      Name="Stephen", Surname = "King", Country = "USA", Id = 1,
             *      Book = new List<Book>
             *      {
             *          new Book{Name = "Carrie", Year = 1974, AuthorID = 1},
             *          new Book{Name = "The Shining", Year = 1977, AuthorID = 1},
             *          new Book{Name = "Insomnia", Year = 1994, AuthorID = 1},
             *          new Book{Name = "The Green Mile", Year = 1996, AuthorID = 1},
             *          new Book{Name = "11/22/63", Year = 2011, AuthorID = 1},
             *          new Book{Name = "Mr. Mercedes", Year = 2014, AuthorID = 1},
             *          new Book{Name = "Revival", Year = 2014, AuthorID = 1},
             *          new Book{Name = "Elevation", Year = 2018, AuthorID = 1}
             *      }
             *  },
             *  new Author
             *  {
             *      Name = "Joanne", Surname = "Rowling", Country = "Great Britain", Id = 2,
             *      Book = new List<Book>
             *      {
             *          new Book{Name = "Harry Potter and the Philosopher's Stone", Year = 1997, AuthorID = 2},
             *          new Book{Name = "Harry Potter and the Chamber of Secrets", Year = 1998, AuthorID = 2},
             *          new Book{Name = "Harry Potter and the Prisoner of Azkaban", Year = 1999, AuthorID = 2},
             *          new Book{Name = "Harry Potter and the Goblet of Fire", Year = 2000, AuthorID = 2},
             *          new Book{Name = "Harry Potter and the Order of the Phoenix ", Year = 2003, AuthorID = 2},
             *          new Book{Name = "Harry Potter and the Half-Blood Prince", Year = 2005, AuthorID = 2},
             *          new Book{Name = "Harry Potter and the Deathly Hallows", Year = 2007, AuthorID = 2}
             *      }
             *  },
             *  new Author
             *  {
             *      Name="Alexandre", Surname = "Dumas", Country = "France", Id = 3,
             *      Book = new List<Book>
             *      {
             *          new Book{Name = "Vingt Ans Apres", Year = 1845, AuthorID = 3},
             *          new Book{Name = " The Count Of Monte Cristo", Year =1846, AuthorID = 3},
             *          new Book{Name = " The Queen's Necklace", Year = 1850, AuthorID = 3},
             *          new Book{Name = "The Black Tulip ", Year = 1850, AuthorID = 3},
             *      }
             *  },
             *  new Author
             *  {
             *      Name="Jules Gabriel", Surname = "Verne", Country = "France", Id = 4,
             *      Book = new List<Book>
             *      {
             *          new Book{Name = "20,000 Leagues Under the Sea", Year = 2018, AuthorID = 4},
             *          new Book{Name = "From the Earth to the Moon; And, Round the Moon", Year = 2016, AuthorID = 4},
             *          new Book{Name = "The Jules Verne Anthology", Year = 2014, AuthorID = 4},
             *          new Book{Name = "The Exploration of the World", Year = 2014, AuthorID = 4},
             *      }
             *  },
             *  new Author
             *  {
             *      Name="Haruki", Surname = "Murakami", Country = "Japan", Id = 5,
             *      Book = new List<Book>
             *      {
             *          new Book{Name = "Hear the Wind Sing", Year = 2015, AuthorID = 5},
             *          new Book{Name = "A Wild Sheep Chase", Year = 1989, AuthorID = 5},
             *          new Book{Name = "Norwegian Wood", Year = 1989, AuthorID = 5},
             *          new Book{Name = "After Dark", Year = 2007, AuthorID = 5},
             *          new Book{Name = "1Q84", Year = 2011, AuthorID = 5},
             *          new Book{Name = "The Elephant Vanishes", Year = 1993, AuthorID = 5},
             *          new Book{Name = "Killing Commendatore", Year = 2018, AuthorID = 5},
             *          new Book{Name = "Men Without Women", Year = 2017, AuthorID = 5},
             *          new Book{Name = "Underground", Year = 2000, AuthorID = 5}
             *      }
             *  },
             * };*/
            #endregion
        }