public static void Test() { var(musicTracksId, artistsId) = MusicGenerator.GenerateMusicTrackId(); var trackDetails = ( from artist in artistsId where artist.Name == "Rob Miles" join track in musicTracksId on artist.Id equals track.ArtistId select new TrackDetails { ArtistName = artist.Name, Title = track.Title } ); foreach (var track in trackDetails) { Console.WriteLine($"Artist: {track.ArtistName} Titile: {track.Title}"); } }
public static void Test() { var(musicTracksId, artistsId) = MusicGenerator.GenerateMusicTrackId(); var artistSummary = ( from track in musicTracksId join artist in artistsId on track.ArtistId equals artist.Id group track by artist.Name into artistTrackSummary select new { Id = artistTrackSummary.Key, Count = artistTrackSummary.Count() } ).ToList(); foreach (var item in artistSummary) { Console.WriteLine($"Artist: {item.Id} Tracks recorded: {item.Count}"); } }