static void TestPManyToMany() { using (ModelManyToManyContainer context = new ModelManyToManyContainer()) { Artist artist = new Artist() { FirstName = "Artist FirstName ", LastName = "Artist LastName " }; Artist artist2 = new Artist() { FirstName = "Artist 2 FirstName ", LastName = "Artist 2 LastName " }; Album album = new Album() { AlbumName = "Album " }; artist.Albums.Add(album); artist2.Albums.Add(album); album.Artists.Add(artist); album.Artists.Add(artist2); context.Artists.Add(artist); context.Artists.Add(artist2); context.Albums.Add(album); context.SaveChanges(); } Console.WriteLine("Verificati baza de date pentru confirmarea testarii many to many"); }
static void TestManyToMany() { using (ModelManyToManyContainer context = new ModelManyToManyContainer()) { Artist artist = new Artist() { FirstName = "John2", LastName = "Doe2" }; Album album = new Album() { AlbumName = "First Album2" }; context.Artists.Add(artist); artist.Albums.Add(album); context.Albums.Add(album); context.SaveChanges(); var allAlbums = context.Albums; foreach (var a in allAlbums) { Console.WriteLine(a + " "); } } }
public static void TestManyToMany() { using (ModelManyToManyContainer context = new ModelManyToManyContainer()) { Album album = new Album { AlbumName = "AlbumName" }; Artist artist = new Artist { FirstName = "FirstName", LastName = "LastName" }; context.Albums.Add(album); context.Artists.Add(artist); context.SaveChanges(); var albums = context.Albums; foreach (var alb in albums) { Console.WriteLine("Album: {0} {1}", alb.AlbumId, alb.AlbumName); } var artists = context.Artists; foreach (var art in artists) { Console.WriteLine("Artist: {0} {1} {2}", art.ArtistId, art.FirstName, art.LastName); } } }
static void TestManyToMany() { Console.WriteLine("Many to many association"); using (ModelManyToManyContainer context = new ModelManyToManyContainer()) { Album album1 = new Album() { AlbumName = "Album 1" }; Album album2 = new Album() { AlbumName = "Album 2" }; Album album3 = new Album() { AlbumName = "Album 3" }; Artist artist1 = new Artist() { FirstName = "Mr.", LastName = "Artist 1" }; Artist artist2 = new Artist() { FirstName = "Mr.", LastName = "Artist 2" }; album1.Artists.Add(artist1); album1.Artists.Add(artist2); artist2.Albums.Add(album2); artist2.Albums.Add(album3); context.Albums.Add(album1); context.Albums.Add(album2); context.Albums.Add(album3); context.Artists.Add(artist1); context.Artists.Add(artist2); context.SaveChanges(); var artists = context.Artists; foreach (var x in artists) { Console.WriteLine("Artist : {0} {1}", x.FirstName, x.LastName); foreach (var ox in x.Albums) { Console.WriteLine("\tAlbum: {0}", ox.AlbumName); } } } }
static void TestManyToMany() { using (ModelManyToManyContainer context = new ModelManyToManyContainer()) { string answer = ""; Console.WriteLine("Do you want to introduce an album? (y/n)"); answer = Console.ReadLine(); if (answer.Contains("y")) { Album album = new Album(); Console.WriteLine("Give the album name"); context.Albums.Add(album); context.SaveChanges(); } Console.WriteLine("Do you want to introduce an artist? (y/n)"); answer = Console.ReadLine(); if (answer.Contains("y")) { Artist artist = new Artist(); Console.WriteLine("Give the artist's first name"); artist.FirstName = Console.ReadLine(); Console.WriteLine("Give the artist's last name "); artist.LastName = Console.ReadLine(); context.Artists.Add(artist); context.SaveChanges(); } Console.WriteLine("Do you want to link an album to an artist? (y/n)"); answer = Console.ReadLine(); if (answer.Contains("y")) { AlbumArtist albumArtist = new AlbumArtist(); Console.WriteLine("Give the artist's id"); albumArtist.Artists_ArtistId = Int32.Parse(Console.ReadLine()); Console.WriteLine("Give the album's id "); albumArtist.Albums_AlbumId = Int32.Parse(Console.ReadLine()); //context.AlbumArtists.Add(albumArtist); Artist artist = context.Artists.FirstOrDefault(a => a.ArtistId == albumArtist.Artists_ArtistId); Album album = context.Albums.FirstOrDefault(a => a.AlbumId == albumArtist.Albums_AlbumId); artist.Albums.Add(album); album.Artists.Add(artist); context.Entry <Artist>(artist).CurrentValues.SetValues(artist); context.Entry <Album>(album).CurrentValues.SetValues(album); //context.Albums.First(a => a.AlbumId == albumArtist.Albums_AlbumId).Artists.Add(artist); //context.Artists.FirstOrDefault(a => a.ArtistId == albumArtist.Artists_ArtistId).Albums.Add(album); context.SaveChanges(); } var items = context.Albums.Include("Artists"); foreach (var x in items) { Console.Write("Album : {0}, {1} ", x.AlbumId, x.AlbumName); foreach (var y in x.Artists) { Console.Write("Artist : {0}, {1}, {2}", y.ArtistId, y.FirstName, y.LastName); } Console.WriteLine(); } } }
static void TestManyToMany() { Console.WriteLine("\nMany to many association"); using (ModelManyToManyContainer context = new ModelManyToManyContainer()) { Console.WriteLine("FirstName:"); Console.WriteLine("LastName:"); Artist artist1 = new Artist() { FirstName = Console.ReadLine(), LastName = Console.ReadLine() }; Console.WriteLine("Album Name"); Album album1 = new Album() { Name = Console.ReadLine(), Artists = new List <Artist>() { artist1 } }; Console.WriteLine("Album Name"); Album album2 = new Album() { Name = Console.ReadLine(), Artists = new List <Artist>() { artist1 } }; context.Artists.Add(artist1); context.Albums.Add(album1); context.Albums.Add(album2); context.SaveChanges(); foreach (var artist in context.Artists) { Console.WriteLine("Name: {0} {1}", artist.FirstName, artist.LastName); foreach (var album in artist.Albums) { Console.WriteLine("Album: {0} Id: {1}", album.Id, album.Name); } } } }