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();
}
}