private static void ViewData3() { using (var context = new EFRecipesEntities1()) { Console.WriteLine("Artists and their albums..."); var artists = context.Artists; foreach (var artist in artists) { Console.WriteLine("{0} {1}", artist.FirstName, artist.LastName); foreach (var album in artist.Albums) { Console.WriteLine("\t{0}", album.AlbumName); } } Console.WriteLine("\nAlbums and their artists..."); var albums = context.Albums; foreach (var album in albums) { Console.WriteLine("{0}", album.AlbumName); foreach (var artist in album.Artists) { Console.WriteLine("\t{0} {1}", artist.FirstName, artist.LastName); } } } }
/*CH2 Recipe3*/ private static void AddDataRec3() { using (var context = new EFRecipesEntities1()) { // add an artist with two albums var artist = new Artist { FirstName = "Alan", LastName = "Jackson" }; var album1 = new Album { AlbumName = "Drive" }; var album2 = new Album { AlbumName = "Live at Texas Stadium" }; artist.Albums.Add(album1); artist.Albums.Add(album2); context.Artists.Add(artist); // add an album for two artists var artist1 = new Artist { FirstName = "Tobby", LastName = "Keith" }; var artist2 = new Artist { FirstName = "Merle", LastName = "Haggard" }; var album = new Album { AlbumName = "Honkytonk University" }; // artist1.Albums.Add(album); //artist2.Albums.Add(album); album.Artists.Add(artist1); album.Artists.Add(artist2); context.Albums.Add(album); context.SaveChanges(); } }