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