static void Main(string[] args)
{
string[] artistNames = new string[] { "Rob Miles", "Fred Bloggs", "The Bloggs Singers", "Immy Brown" };
string[] titleNames = new string[] { "My Way", "Your Way", "His Way", "Her Way", "Milky Way" };
List <Artist> Artists = new List <Artist>();
List <MusicTrack> MusicTracks = new List <MusicTrack>();
Random rand = new Random(1);
int IDcount = 0;
foreach (string artistName in artistNames)
{
Artist newArtist = new Artist {
ID = IDcount++, Name = artistName
};
Artists.Add(newArtist);
foreach (string titleName in titleNames)
{
MusicTrack newTrack = new MusicTrack
{
ID = IDcount++,
ArtistID = newArtist.ID,
Title = titleName,
Length = rand.Next(20, 600)
};
MusicTracks.Add(newTrack);
}
}
var artistSummary = from artist in Artists
orderby artist.Name
join track in MusicTracks on artist.ID equals track.ArtistID
group track by artist.Name into artistTrackSummary
select
new
{
ArtistName = artistTrackSummary.Key,
Length = artistTrackSummary.Sum(x => x.Length)
};
foreach (var summary in artistSummary)
{
Console.WriteLine("Name:{0} Total length:{1}",
summary.ArtistName, summary.Length);
}
Console.ReadKey();
}
static void Main(string[] args)
{
string[] artistNames = new string[] { "Rob Miles", "Fred Bloggs", "The Bloggs Singers", "Immy Brown" };
string[] titleNames = new string[] { "My Way", "Your Way", "His Way", "Her Way", "Milky Way" };
List <Artist> Artists = new List <Artist>();
List <MusicTrack> MusicTracks = new List <MusicTrack>();
Random rand = new Random(1);
int IDcount = 0;
foreach (string artistName in artistNames)
{
Artist newArtist = new Artist {
ID = IDcount++, Name = artistName
};
Artists.Add(newArtist);
foreach (string titleName in titleNames)
{
MusicTrack newTrack = new MusicTrack
{
ID = IDcount++,
ArtistID = newArtist.ID,
Title = titleName,
Length = rand.Next(20, 600)
};
MusicTracks.Add(newTrack);
}
}
var artistSummary = MusicTracks.Join(
Artists,
track => track.ArtistID,
artist => artist.ID,
(track, artist) =>
new
{
track = track,
artist = artist
}
)
.GroupBy(
temp0 => temp0.artist.Name,
temp0 => temp0.track
)
.Select(
artistTrackSummary =>
new
{
ID = artistTrackSummary.Key,
Length = artistTrackSummary.Sum(x => x.Length)
}
);
foreach (var summary in artistSummary)
{
Console.WriteLine("Name:{0} Total length:{1}",
summary.ID, summary.Length);
}
Console.ReadKey();
}