static void PrintBooksFromReaders() { using var context = new WithJoinEntityContext(); var readers = context.Readers.Include(n => n.ReaderBooks).ThenInclude(n => n.Book).ToList(); foreach (var reader in readers) { Console.WriteLine($"Books read by {reader.Name}:"); foreach (var readerBooks in reader.ReaderBooks) { Console.WriteLine($"\t{readerBooks.Book.Title}"); } } }
static void PupulateDatabase() { using var context = new WithJoinEntityContext(); if (!context.Set <ReaderBook>().Any()) { var cleanCode = new Book() { Title = "Clean Code" }; context.Books.Add(cleanCode); var ddd = new Book() { Title = "Domain Driven Design" }; context.Books.Add(ddd); var alexandre = new Reader() { Name = "Alexandre" }; context.Readers.Add(alexandre); var michelle = new Reader() { Name = "Michelle" }; context.Readers.Add(michelle); context.Set <ReaderBook>().Add(new ReaderBook() { Reader = alexandre, Book = cleanCode }); context.Set <ReaderBook>().Add(new ReaderBook() { Reader = alexandre, Book = ddd }); context.Set <ReaderBook>().Add(new ReaderBook() { Reader = michelle, Book = cleanCode }); context.SaveChanges(); } }