public static void Main(string[] args) { //Collections to work with List <Artist> Artists = MusicStore.GetData().AllArtists; List <Group> Groups = MusicStore.GetData().AllGroups; //======================================================== //Solve all of the prompts below using various LINQ queries //======================================================== //There is only one artist in this collection from Mount Vernon, what is their name and age? var OneArtist = Artists.Select(Artist => new { name = Artist.RealName, age = Artist.Age, hometown = Artist.Hometown }).FirstOrDefault(artist => artist.hometown == "Mount Vernon"); Console.WriteLine(OneArtist); //Who is the youngest artist in our collection of artists? //Display all artists with 'William' somewhere in their real name //Display the 3 oldest artist from Atlanta //(Optional) Display the Group Name of all groups that have members that are not from New York City //(Optional) Display the artist names of all members of the group 'Wu-Tang Clan' Console.WriteLine(Groups.Count); }
public static void Main(string[] args) { //Collections to work with List <Artist> Artists = MusicStore.GetData().AllArtists; List <Group> Groups = MusicStore.GetData().AllGroups; //======================================================== //Solve all of the prompts below using various LINQ queries //======================================================== //There is only one artist in this collection from Mount Vernon, what is their name and age? // List<Artist> ArtistsFromMV = Artists.Where(art => art.Hometown == "Mount Vernon").ToList(); List <Artist> ArtistsFromMV = Artists.Where(art => art.Hometown.Contains("Mount Vernon")).ToList(); //Who is the youngest artist in our collection of artists? Artist Youngest = Artists.OrderBy(art => art.Age).FirstOrDefault(); //Display all artists with 'William' somewhere in their real name List <Artist> Williams = Artists.Where(art => art.RealName.Contains("William")).ToList(); //Display the 3 oldest artist from Atlanta List <Artist> Oldest = Artists.Where(art => art.Hometown == "Atlanta").OrderByDescending(art => art.Age).Take(3).ToList(); //(Optional) Display the Group Name of all groups that have members that are not from New York City var NotNYC = Groups.Join(Artists, g => g.Id, a => a.GroupId, (group, artist) => group).Where(group => group.Members.All(artist => artist.Hometown != "New York City")).ToList(); //(Optional) Display the artist names of all members of the group 'Wu-Tang Clan' List <string> WuTangClan = Artists.Join(Groups, art => art.GroupId, gro => gro.Id, (artist, group) => artist).Where(artist => artist.Group.GroupName == "Wu-Tang Clan").Select(artist => artist.ArtistName).ToList(); Console.WriteLine("------------------------------------------------------------------------------------------------------------------------"); Console.WriteLine(Groups.Count); Console.WriteLine(Artists.Count); Console.WriteLine("------------------------------------------------------------------------------------------------------------------------"); }
public static void Main(string[] args) { //Collections to work with List <Artist> Artists = MusicStore.GetData().AllArtists; List <Group> Groups = MusicStore.GetData().AllGroups; //======================================================== //Solve all of the prompts below using various LINQ queries //======================================================== //There is only one artist in this collection from Mount Vernon, what is their name and age? Artist xxxx = Artists.FirstOrDefault( x => x.Hometown == "Mount Vernon"); System.Console.WriteLine(xxxx.ArtistName); //Who is the youngest artist in our collection of artists? Artist youngest = Artists.FirstOrDefault( city => city.Age == Artists.Min(c => c.Age) ); System.Console.WriteLine(youngest.ArtistName + " " + youngest.Age); //Display all artists with 'William' somewhere in their real name var William = Artists.Where( name => name.RealName.Contains("William")); foreach (var will in William) { System.Console.WriteLine(will.ArtistName); } //Display the 3 oldest artist from Atlanta var Atlanta = Artists.Where( name => name.Hometown.Contains("Atlanta")); var old = Atlanta.OrderByDescending( Age => Age.Age).Take(3); foreach (var ATL in old) { System.Console.WriteLine(ATL.ArtistName + " " + ATL.Age + " " + ATL.Hometown); } //(Optional) Display the Group Name of all groups that have members that are not from New York City //(Optional) Display the artist names of all members of the group 'Wu-Tang Clan' // Console.WriteLine(Groups.Count); }
public static void Main(string[] args) { //Collections to work with List <Artist> Artists = MusicStore.GetData().AllArtists; List <Group> Groups = MusicStore.GetData().AllGroups; //======================================================== //Solve all of the prompts below using various LINQ queries //======================================================== //There is only one artist in this collection from Mount Vernon, what is their name and age? Artist mountVernon = Artists.FirstOrDefault(homeTown => homeTown.Hometown == "Mount Vernon"); //Who is the youngest artist in our collection of artists? Artist bby = Artists.OrderBy(art => art.Age).FirstOrDefault(); //Display all artists with 'William' somewhere in their real name IEnumerable <Artist> william = Artists.Where(art => art.RealName.Contains("William")); //Display the 3 oldest artist from Atlanta IEnumerable <Artist> atlanteans = Artists.Where(art => art.Hometown == "Atlanta").OrderByDescending(art => art.Age).Take(3); //(Optional) Display the Group Name of all groups that have members that are not from New York City IEnumerable <Group> notNY = Groups.Join(Artists, gr => gr.Id, art => art.GroupId, (gr, art) => { gr.Members.Add(art); return(gr); }).Where(gr => gr.Members.All(art => art.Hometown != "New York City")).Distinct(); //(Optional) Display the artist names of all members of the group 'Wu-Tang Clan' IEnumerable <Group> wutang = Groups.Join(Artists, gr => gr.Id, art => art.GroupId, (gr, art) => { gr.Members.Add(art); return(gr); }).Distinct(); Console.WriteLine(Groups.Count); Console.WriteLine(mountVernon.RealName); Console.WriteLine(mountVernon.Age); Console.WriteLine($"{bby.RealName},{bby.Age},{bby.ArtistName}"); foreach (Artist will in william) { Console.WriteLine($"{will.RealName}"); } foreach (Artist atl in atlanteans) { Console.WriteLine($"{atl.ArtistName}({atl.RealName})-{atl.Age}"); } foreach (Group meme in notNY) { Console.WriteLine($"{meme.GroupName}"); } foreach (var gr in wutang) { if (gr.GroupName == "Wu-Tang Clan") { foreach (Artist meme in gr.Members) { Console.WriteLine($"{meme.ArtistName}-{meme.RealName}"); } } } }
public static void Main(string[] args) { //Collections to work with List <Artist> Artists = MusicStore.GetData().AllArtists; List <Group> Groups = MusicStore.GetData().AllGroups; //======================================================== //Solve all of the prompts below using various LINQ queries //======================================================== //There is only one artist in this collection from Mount Vernon, what is their name and age? Artist buddy = Artists.SingleOrDefault(person => person.Hometown == "Mount Vernon"); Console.WriteLine(buddy.RealName); Console.WriteLine(buddy.Age); //Who is the youngest artist in our collection of artists? IEnumerable <Artist> orderedAges = Artists.OrderBy(person => person.Age); Artist youngBuddy = orderedAges.FirstOrDefault(); Console.WriteLine($"{youngBuddy.ArtistName} is from {youngBuddy.Hometown}, but their real name is {youngBuddy.RealName} and they are {youngBuddy.Age} years old, making them the youngest on the list."); //Display all artists with 'William' somewhere in their real name IEnumerable <Artist> WhereMyWillies = Artists.Where(pal => pal.RealName.Contains("William")); foreach (Artist willy in WhereMyWillies) { Console.WriteLine($"{willy.ArtistName}'s real name is {willy.RealName}."); } //Display the 3 oldest artist from Atlanta IEnumerable <Artist> elders = Artists.Where(person => person.Hometown == "Atlanta"); IEnumerable <Artist> orderedElders = elders.OrderByDescending(dude => dude.Age); IEnumerable <Artist> takenElders = orderedElders.Take(3); foreach (Artist eldie in takenElders) { Console.WriteLine($"My name is {eldie.RealName} and I am {eldie.Age} years old."); } //Display all groups with names less than 8 characters in length. IEnumerable <Group> groups = Groups.Where(grp => grp.GroupName.Length < 8); foreach (Group g in groups) { Console.WriteLine($"The length of this group name, {g.GroupName}, is less than 8 characters."); } //(Optional) Display the Group Name of all groups that have members that are not from New York City //(Optional) Display the artist names of all members of the group 'Wu-Tang Clan' Console.WriteLine(Groups.Count); }
public static void Main(string[] args) { //Collections to work with List <Artist> Artists = MusicStore.GetData().AllArtists; List <Group> Groups = MusicStore.GetData().AllGroups; //======================================================== //Solve all of the prompts below using various LINQ queries //======================================================== //There is only one artist in this collection from Mount Vernon, what is their name and age? Artist theOne = Artists.FirstOrDefault(art => art.Hometown == "Mount Vernon"); System.Console.WriteLine(theOne.ArtistName + " " + theOne.Age); //Who is the youngest artist in our collection of artists? Artist youngest = Artists.OrderByDescending(a => a.Age).Last(); Console.WriteLine(youngest.ArtistName + " " + youngest.Age); //Display all artists with 'William' somewhere in their real name IEnumerable <Artist> certainArtists = Artists.Where(art => art.RealName.Contains("William")); foreach (var a in certainArtists) { System.Console.WriteLine(a.RealName + " " + a.ArtistName); } //Display all groups with names less than 8 characters in length IEnumerable <Group> shortName = Groups.Where(g => g.GroupName.Length < 8); foreach (var g in shortName) { System.Console.WriteLine(g.GroupName); } //Display the 3 oldest artist from Atlanta IEnumerable <Artist> oldestArtists = Artists.Where(art => art.Hometown == "Atlanta").OrderByDescending(art => art.Age).Take(3); foreach (var a in oldestArtists) { System.Console.WriteLine(a.ArtistName + " " + a.Age); } //(Optional) Display the Group Name of all groups that have members that are not from New York City var Id = Artists.Where(a => a.Hometown != "New York City").Select(a => a.GroupId); //(Optional) Display the artist names of all members of the group 'Wu-Tang Clan' var memberArtists = Groups.Where(g => g.GroupName == "Wu-Tang Clan").Select(g => g.Members.Select(m => m.ArtistName)); foreach (var a in memberArtists) { Console.WriteLine(a); } }
public static void Main(string[] args) { //Collections to work with List <Artist> Artists = MusicStore.GetData().AllArtists; List <Group> Groups = MusicStore.GetData().AllGroups; //======================================================== //Solve all of the prompts below using various LINQ queries //======================================================== //There is only one artist in this collection from Mount Vernon, what is their name and age? List <Artist> mountV = Artists .Where(i => i.Hometown == "Mount Vernon") .ToList(); string mountVArt = $"The only artist in Mount Verson is {mountV[0].RealName}, age {mountV[0].Age}."; System.Console.WriteLine(mountVArt); //Who is the youngest artist in our collection of artists? List <Artist> age = Artists .OrderBy(i => i.Age) .ToList(); string youngest = $"The youngest artist is {age[0].RealName}, age {age[0].Age}."; System.Console.WriteLine(youngest); //Display all artists with 'William' somewhere in their real name List <Artist> willy = Artists .Where(i => i.RealName .Contains("William")) .ToList(); string willies = $"There are {willy.Count} artist that contain the name 'William', there names are:"; for (int i = 0; i < willy.Count; i++) { willies += $" {willy[i].RealName},"; } System.Console.WriteLine(willies); //Display the 3 oldest artist from Atlanta List <Artist> old = Artists .Where(i => i.Hometown == "Atlanta") .OrderByDescending(i => i.Age) .ToList(); string oldest = $"The three oldest artists from Atlanta are {old[0].RealName} age {old[0].Age}, {old[1].RealName} age {old[1].Age}, and {old[2].RealName} age {old[2].Age}."; System.Console.WriteLine(oldest); //(Optional) Display the Group Name of all groups that have members that are not from New York City //(Optional) Display the artist names of all members of the group 'Wu-Tang Clan' // Console.WriteLine(Groups.Count); }
public static void Main(string[] args) { //Collections to work with List <Artist> Artists = MusicStore.GetData().AllArtists; List <Group> Groups = MusicStore.GetData().AllGroups; //======================================================== //Solve all of the prompts below using various LINQ queries //======================================================== //There is only one artist in this collection from Mount Vernon, what is their name and age? List <Artist> FromMV = Artists.Where(a => a.Hometown == "Mount Vernon").ToList(); System.Console.WriteLine($"There are {FromMV.Count} artists from Mount Vernon."); //Who is the youngest artist in our collection of artists? List <Artist> OldestToYoungest = Artists.OrderByDescending(a => a.Age).ToList(); Artist YoungestArtist = OldestToYoungest.Last(); System.Console.WriteLine($"{YoungestArtist.ArtistName} is the youngest artist on the list."); //Display all artists with 'William' somewhere in their real name List <Artist> Williams = Artists.Where(a => a.RealName.Contains("William")).ToList(); System.Console.WriteLine($"Here are real names all of the artists named 'William' or with a last name of 'Williams' in the original list:"); foreach (Artist a in Williams) { System.Console.WriteLine($"{a.RealName}"); } //Display the 3 oldest artist from Atlanta List <Artist> FromATL = Artists.Where(a => a.Hometown == "Atlanta").ToList(); List <Artist> OldestToYoungestATL = FromATL.OrderByDescending(a => a.Age).ToList(); System.Console.WriteLine("The three oldest artists on the original list who are from Atlanta are:"); for (int i = 0; i <= 2; i++) { System.Console.WriteLine($"{OldestToYoungest[i].RealName}"); } //(Optional) Display the Group Name of all groups that have members that are not from New York City //(Optional) Display the artist names of all members of the group 'Wu-Tang Clan' Console.WriteLine($"There are {Groups.Count} groups, apparently."); System.Console.WriteLine("One of these groups is worth particular note, as it is said they are not to be challenged or confronted lightly."); System.Console.WriteLine("Their names are:"); List <Artist> WuTangClan = Artists.Where(a => a.GroupId == 1).ToList(); foreach (Artist a in WuTangClan) { System.Console.WriteLine($"{a.ArtistName}"); } System.Console.WriteLine("Together, they are known as 'The Wu-Tang Clan.'"); }
public static void Main(string[] args) { //Collections to work with List <Artist> Artists = MusicStore.GetData().AllArtists; List <Group> Groups = MusicStore.GetData().AllGroups; //======================================================== //Solve all of the prompts below using various LINQ queries //======================================================== //There is only one artist in this collection from Mount Vernon, what is their name and age? IEnumerable <Artist> Mountvernonartist = Artists.Where(a => a.Hometown == "Mount Vernon"); foreach (var b in Mountvernonartist) { System.Console.WriteLine(b.ArtistName + " and " + b.Hometown); } Console.WriteLine("\n~~~~~~~~~\n"); //Who is the youngest artist in our collection of artists? int YoungestArtist = Artists.Min(b => b.Age); Artist artistname = Artists.FirstOrDefault(b => b.Age == YoungestArtist); { System.Console.WriteLine(YoungestArtist + "" + artistname.RealName); } //Display all artists with 'William' somewhere in their real name IEnumerable <Artist> Wartists = Artists.Where(b => b.RealName.Contains("William")); System.Console.WriteLine("These artist's names are William"); foreach (var Artist in Wartists) { System.Console.WriteLine(Artist.RealName); } System.Console.WriteLine("......................................................."); //Display the 3 oldest artist from Atlanta var atOldest = Artists .Where(art => art.Hometown == "Atlanta") .OrderByDescending(art => art.Age) .Take(3); System.Console.WriteLine("The three oldest artists from atlanta ="); foreach (var artist in atOldest) { System.Console.WriteLine(artist.ArtistName); } System.Console.WriteLine("....................................................."); //(Optional) Display the Group Name of all groups that have members that are not from New York City //(Optional) Display the artist names of all members of the group 'Wu-Tang Clan' // Console.WriteLine(Groups.Count); }
public static void Main(string[] args) { //Collections to work with List <Artist> Artists = MusicStore.GetData().AllArtists; List <Group> Groups = MusicStore.GetData().AllGroups; //======================================================== //Solve all of the prompts below using various LINQ queries //======================================================== //There is only one artist in this collection from Mount Vernon, what is their name and age? Artist mv = Artists.FirstOrDefault(a => a.Hometown == "Mount Vernon"); Console.WriteLine($"{mv.ArtistName} is from {mv.Hometown}"); //Who is the youngest artist in our collection of artists? // orderby on age, pick the first OR on age desc, pick the last Artist youngest = Artists.OrderByDescending(a => a.Age) .LastOrDefault(); Artist youngest2 = Artists.FirstOrDefault( a => a.Age == Artists.Min(ar => ar.Age) ); //Display all artists with 'William' somewhere in their real name var williams = Artists .Where(a => a.RealName.ToLower() .Contains("william")) .Select(a => new { real = a.RealName, alias = a.ArtistName }).ToList(); //Display the 3 oldest artist from Atlanta var OGs = Artists .Where(a => a.Hometown == "Atlanta") .OrderByDescending(a => a.Age) // LIMIT 3 .Take(3); int[] nums = { 1, 4, 6, 7 }; string[] strNums = nums.Select(num => num.ToString()).ToArray(); //(Optional) Display the Group Name of all groups that have members that are not from New York City var groupsNotFromNy = Groups.Where( g => g.Members.Any(m => m.Hometown != "New York City") ).ToArray(); //(Optional) Display the artist names of all members of the group 'Wu-Tang Clan' Console.WriteLine(Groups.Count); }
public static void Main(string[] args) { //Collections to work with List <Artist> Artists = MusicStore.GetData().AllArtists; List <Group> Groups = MusicStore.GetData().AllGroups; //======================================================== //Solve all of the prompts below using various LINQ queries //======================================================== //There is 2 artists in this collection from Mount Vernon, what is their name and age? List <Artist> MountVernonArtists = Artists.Where(a => a.Hometown == "Mount Vernon").ToList(); foreach (Artist a in MountVernonArtists) { System.Console.WriteLine($"#1: {a.ArtistName} {a.Age}"); } //Who is the youngest artist in our collection of artists? Artist YoungestArtist = Artists.OrderBy(a => a.Age).First(); System.Console.WriteLine($"#2: {YoungestArtist.ArtistName}: {YoungestArtist.Age}"); //Display all artists with 'William' somewhere in their real name List <Artist> ArtistsWilliam = Artists.Where(a => a.RealName.Contains("William")).ToList(); foreach (Artist a in ArtistsWilliam) { System.Console.WriteLine($"#3: {a.RealName}"); } //Display the 3 oldest artist from Atlanta List <Artist> AllArtistsAtlanta = Artists.Where(a => a.Hometown == "Atlanta").OrderByDescending(a => a.Age).ToList(); foreach (Artist a in AllArtistsAtlanta) { System.Console.WriteLine($"4b: {a.RealName} - {a.Age}"); } List <Artist> ThreeOldestArtistsAtlanta = Artists.Where(a => a.Hometown == "Atlanta").OrderByDescending(a => a.Age).Take(3).ToList(); foreach (Artist a in ThreeOldestArtistsAtlanta) { System.Console.WriteLine($"4a: {a.RealName} - {a.Age}"); System.Console.WriteLine(); } //(Optional) Display the Group Name of all groups that have members that are not from New York City // IEnumerable<Group> AllGroupsNotNY = Groups.Where(a => a.Members == "NewYork"); //(Optional) Display the artist names of all members of the group 'Wu-Tang Clan' // Console.WriteLine(Groups.Count); }
public static void Main(string[] args) { //Collections to work with List <Artist> Artists = MusicStore.GetData().AllArtists; List <Group> Groups = MusicStore.GetData().AllGroups; //======================================================== //Solve all of the prompts below using various LINQ queries //======================================================== //There is only one artist in this collection from Mount Vernon, what is their name and age? Artist MtVernonArtist = Artists.FirstOrDefault(artist => artist.Hometown == "Mount Vernon"); Console.WriteLine(MtVernonArtist.ArtistName); Console.WriteLine(MtVernonArtist.Age); // Name: DMX // Age: 46 //Who is the youngest artist in our collection of artists? Artist YoungestArtist = Artists.FirstOrDefault(art => art.Age == Artists.Min(artist => artist.Age)); Console.WriteLine(YoungestArtist.ArtistName); Console.WriteLine(YoungestArtist.Age); // Youngest artist: Chance the Rapper, 23 //Display all artists with 'William' somewhere in their real name List <Artist> AllWilliams = Artists.Where(artist => artist.RealName.Contains("William")).ToList(); PrintEach(AllWilliams); // Bryan Williams, Robert Williams, William Roberts, William Griffin //Display the 3 oldest artist from Atlanta List <Artist> OldestArtistsFrAtlanta = Artists.Where(artist => artist.Hometown == "Atlanta").OrderByDescending(artist => artist.Age).Take(3).ToList(); PrintEach(OldestArtistsFrAtlanta); // 3 oldest artists from Atlanta: Ludacris (39), Andre 3000 (41), Lil Jon (45) //(Optional) Display the Group Name of all groups that have members that are not from New York City List <Group> GroupsNotNYC = Groups.Where(group => group.Members.All(member => member.Hometown != "New York City")).ToList(); PrintEach(GroupsNotNYC); //(Optional) Display the artist names of all members of the group 'Wu-Tang Clan' List <IEnumerable <string> > WuTangClan = Groups.Where(group => group.GroupName == "Wu-Tang Clan").Select(group => group.Members.Select(u => u.ArtistName)).ToList(); foreach (var group in WuTangClan) { foreach (var member in group) { Console.WriteLine(member); } } }
public static void Main(string[] args) { //Collections to work with List <Artist> Artists = MusicStore.GetData().AllArtists; List <Group> Groups = MusicStore.GetData().AllGroups; //======================================================== //Solve all of the prompts below using various LINQ queries //======================================================== //There is only one artist in this collection from Mount Vernon, what is their name and age? Artist mtVernonArtist = Artists.FirstOrDefault(a => a.Hometown == "Mount Vernon"); Console.WriteLine($"The only artist from Mt Vernon is {mtVernonArtist.ArtistName} (Age: {mtVernonArtist.Age}), who was born as {mtVernonArtist.RealName}."); //Who is the youngest artist in our collection of artists? Artist youngestArtist = Artists.FirstOrDefault(a => a.Age == Artists.Min(age => age.Age)); Console.WriteLine($"The youngest artist is {youngestArtist.ArtistName} (Age: {youngestArtist.Age}). Born as {youngestArtist.RealName}."); //Display all artists with 'William' somewhere in their real name IEnumerable <Artist> Williams = Artists.Where(a => a.RealName.Contains("William")).ToList(); Console.WriteLine("The following artists all have William somewhere in their name"); foreach (Artist artist in Williams) { Console.WriteLine($"Name: {artist.ArtistName} Real Name: {artist.RealName} "); } //Display the 3 oldest artist from Atlanta IEnumerable <Artist> topThreeOldest = Artists .Where(a => a.Hometown == "Atlanta") .OrderByDescending(a => a.Age) .Take(3); Console.WriteLine("The following are the 3 oldest artists from Atlanta"); foreach (Artist artist in topThreeOldest) { Console.WriteLine($"Name: {artist.ArtistName} Real Name: {artist.RealName}"); } //(Optional) Display the Group Name of all groups that have members that are not from New York City //(Optional) Display the artist names of all members of the group 'Wu-Tang Clan' Console.WriteLine(Groups.Count); }
public static void Main(string[] args) { //Collections to work with List <Artist> Artists = MusicStore.GetData().AllArtists; List <Group> Groups = MusicStore.GetData().AllGroups; //======================================================== //Solve all of the prompts below using various LINQ queries //======================================================== //There is only one artist in this collection from Mount Vernon, what is their name and age? // List<Artist> MountVern = Artists.Where(a => a.Hometown == "Mount Vernon").ToList(); // System.Console.WriteLine($"Artist Name from Mount Vernon: {MountVern[0].ArtistName}; Age: {MountVern[0].Age}"); //Who is the youngest artist in our collection of artists? // Artist youngest = Artists.OrderByDescending(a => a.Age).Last(); // System.Console.WriteLine($"Youngest Artist Name: {youngest.ArtistName}; Age: {youngest.Age}"); //Display all artists with 'William' somewhere in their real name // List<Artist> William = Artists.Where(a => a.RealName.Contains("William")).ToList(); // foreach(var bill in William){ // System.Console.WriteLine($"Real Name: {bill.RealName}; Artist Name: {bill.ArtistName}"); // } // Display all groups with names less than 8 characters in length. // List<Group> name = Groups.Where(g => g.GroupName.Length < 8).ToList(); // System.Console.WriteLine(name.Count); // foreach (var group in name){ // System.Console.WriteLine($"Group Name: {group.GroupName}"); // } //Display the 3 oldest artist from Atlanta // List<Artist> FromAtlanta = Artists.Where(a => a.Hometown == "Atlanta").OrderByDescending(a => a.Age).Take(3).ToList(); // foreach (var a in FromAtlanta){ // System.Console.WriteLine(a.ArtistName); // } //(Optional) Display the Group Name of all groups that have members that are not from New York City //(Optional) Display the artist names of all members of the group 'Wu-Tang Clan' Group WuTang = Groups.First(g => g.GroupName == "Wu-Tang Clan"); foreach (var artist in WuTang.Members) { System.Console.WriteLine($"Name: {artist.ArtistName}"); } // Console.WriteLine(Groups.Count); }
public static void Main(string[] args) { //Collections to work with List <Artist> Artists = MusicStore.GetData().AllArtists; List <Group> Groups = MusicStore.GetData().AllGroups; //There is only one artist in this collection from Mount Vernon, what is their name and age? Artist vernonArtist = Artists.FirstOrDefault(artist => artist.Hometown == "Mount Vernon"); Console.WriteLine(vernonArtist.ArtistName, vernonArtist.Age); //Who is the youngest artist in our collection of artists? List <Artist> youngestArtist = Artists.OrderBy(artists => artists.Age).ToList(); Console.WriteLine(youngestArtist[0].ArtistName); //Display all artists with 'William' somewhere in their real name List <Artist> william = Artists.Where(artists => artists.RealName.Contains("William")).ToList(); Console.WriteLine(william); // Display all groups with names less than 8 characters in length. List <Group> eightCharacters = Groups.Where(groups => groups.GroupName.Length == 8).ToList(); Console.WriteLine(eightCharacters); //Display the 3 oldest artist from Atlanta List <Artist> ATL = Artists.OrderByDescending(artists => artists.Hometown.Contains("Atlanta")).ToList(); Console.WriteLine(ATL[0].ArtistName); Console.WriteLine(ATL[1].ArtistName); Console.WriteLine(ATL[2].ArtistName); //(Optional) Display the Group Name of all groups that have members that are not from New York City var joinedGroups = Groups.Join(Artists, g => g.Id, a => a.GroupId, (joinedGroups, joinedA) => { joinedGroups.Members.Add(joinedA); return(joinedGroups); }).ToList(); List <Group> notNewYork = joinedGroups.Where(g => g.Members.Any(a => a.Hometown != "New York City")).ToList(); //(Optional) Display the artist names of all members of the group 'Wu-Tang Clan' // List<Group> wuTangClan = joinedGroups.Where(g => g.GroupName.Contains("Wu-Tang Clan").Select(g.Members)).ToList(); List <Artist> WTmembers = Groups.FirstOrDefault(g => g.GroupName == "Wu-Tang Clan").Members; foreach (var member in WTmembers) { Console.WriteLine(member.ArtistName); } Console.WriteLine(Groups.Count); }
public static void Main(string[] args) { //Collections to work with List <Artist> Artists = MusicStore.GetData().AllArtists; List <Group> Groups = MusicStore.GetData().AllGroups; //======================================================== //Solve all of the prompts below using various LINQ queries //======================================================== //There is only one artist in this collection from Mount Vernon, what is their name and age? var ArtistFromMountVernon = from artist in Artists where artist.Hometown == "Mount Vernon" select new { artist.RealName }; foreach (var i in ArtistFromMountVernon) { Console.WriteLine(i); } //Who is the youngest artist in our collection of artists? var YoungestArtist = Artists.OrderBy(artist => artist.Age).First(); Console.WriteLine(YoungestArtist.ArtistName + YoungestArtist.Age); var YoungestAge = Artists.Min(artist => artist.Age); var YoungestArtist2 = Artists.Where(artist => artist.Age == YoungestAge); foreach (var i in YoungestArtist2) { Console.WriteLine(i.ArtistName + i.Age); } //Display all artists with 'William' somewhere in their real name var ArtistNamedWilliam = Artists.Where(artist => artist.RealName.Contains("William")); foreach (var i in ArtistNamedWilliam) { Console.WriteLine(i.ArtistName); } //Display the 3 oldest artist from Atlanta var ArtistFromAtlanta = Artists.Where(artist => artist.Hometown == "Atlanta"); var OldestThree = ArtistFromAtlanta.OrderByDescending(artist => artist.Age).Take(3); foreach (var i in OldestThree) { Console.WriteLine(i.ArtistName); } //(Optional) Display the Group Name of all groups that have members that are not from New York City //(Optional) Display the artist names of all members of the group 'Wu-Tang Clan' // Console.WriteLine(Groups.Count); }
public static void Main(string[] args) { //Collections to work with List <Artist> Artists = MusicStore.GetData().AllArtists; List <Group> Groups = MusicStore.GetData().AllGroups; //======================================================== //Solve all of the prompts below using various LINQ queries //======================================================== //There is only one artist in this collection from Mount Vernon, what is their name and age? Artist artist = Artists.FirstOrDefault(city => city.Hometown == "Mount Vernon"); System.Console.WriteLine(artist.ArtistName); //Who is the youngest artist in our collection of artists? int smallest_num = Artists.Min(age => age.Age); var youngest = Artists.Where(age => age.Age == smallest_num); foreach (var art in youngest) { System.Console.WriteLine(art.ArtistName + " : " + art.Age); } System.Console.WriteLine("\n"); //Display all artists with 'William' somewhere in their real name var willIam = Artists.Where(name => name.RealName.Contains("William")); foreach (var will in willIam) { System.Console.WriteLine(will.ArtistName); } System.Console.WriteLine("\n"); //Display the 3 oldest artist from Atlanta var ATL = Artists.Where(artst => artst.Hometown == "Atlanta"); var oldest3 = ATL.OrderByDescending(age => age.Age).Take(3); foreach (var oldest in oldest3) { System.Console.WriteLine(oldest.ArtistName + " from " + oldest.Hometown + " age :" + oldest.Age); } //(Optional) Display the Group Name of all groups that have members that are not from New York City //(Optional) Display the artist names of all members of the group 'Wu-Tang Clan' // Console.WriteLine(Groups.Count); }
public static void Main(string[] args) { //Collections to work with List <Artist> Artists = MusicStore.GetData().AllArtists; List <Group> Groups = MusicStore.GetData().AllGroups; //======================================================== //Solve all of the prompts below using various LINQ queries //======================================================== //There is only one artist in this collection from Mount Vernon, what is their name and age? Artist mountVern = Artists.FirstOrDefault(artist => artist.Hometown == "Mount Vernon"); Console.WriteLine("The Artist from Mount Vernon is :"); Console.WriteLine(mountVern.RealName); Console.WriteLine(); //Who is the youngest artist in our collection of artists? int age = Artists.Min(artist => artist.Age); Artist youngest = Artists.FirstOrDefault(artist => artist.Age == age); Console.WriteLine("The youngest Artist in the Group is :"); Console.WriteLine(youngest.ArtistName + ", " + youngest.Age + " years old"); Console.WriteLine(); //Display all artists with 'William' somewhere in their real name List <Artist> wills = Artists.Where(artist => artist.RealName.Contains("William")).ToList(); wills.ForEach(i => Console.WriteLine("{0}\t", i.RealName + " aka " + i.ArtistName)); Console.WriteLine(); //Display the 3 oldest artist from Atlanta List <Artist> hotlanta = Artists.Where(artist => artist.Hometown == "Atlanta").OrderByDescending(artist => artist.Age).Take(3).ToList(); hotlanta.ForEach(i => Console.WriteLine("{0}\t", i.RealName + " aka " + i.ArtistName + ", " + i.Age + " years old")); Console.WriteLine(); //(Optional) Display the Group Name of all groups that have members that are not from New York City IEnumerable <string> notNyc = Artists.Where(artist => artist.Hometown != "New York City").Join(Groups, artId => artId.GroupId, grpId => grpId.Id, (artId, grpId) => { return(artId.ArtistName + ", " + grpId.GroupName); }); Console.WriteLine(notNyc); //(Optional) Display the artist names of all members of the group 'Wu-Tang Clan' }
public static void Main(string[] args) { //Collections to work with List <Artist> Artists = MusicStore.GetData().AllArtists; List <Group> Groups = MusicStore.GetData().AllGroups; //======================================================== //Solve all of the prompts below using various LINQ queries //======================================================== //There is only one artist in this collection from Mount Vernon, what is their name and age? var artist = Artists.Where( a => a.Hometown == "Mount Vernon") .Select(myArtist => new Artist { RealName = myArtist.RealName, Age = myArtist.Age }); foreach (var art in artist) { System.Console.WriteLine($"Artists from Mount Vernon: Artist Name: {art.ArtistName} Real Name: {art.RealName} Age:{art.Age}"); } //Who is the youngest artist in our collection of artists? var youngest = Artists.OrderByDescending(x => x.Age).Last(); System.Console.WriteLine($"Youngest artist: Artist Name: {youngest.ArtistName} Real Name: {youngest.RealName} Age: {youngest.Age}"); //Display all artists with 'William' somewhere in their real name var williams = Artists.Where(will => will.RealName.Contains("William")); foreach (var will in williams) { System.Console.WriteLine(will.RealName); } //Display the 3 oldest artist from Atlanta var threeoldest = Artists.Where(a => a.Hometown == "Atlanta").OrderByDescending(x => x.Age).Take(3); foreach (var old in threeoldest) { System.Console.WriteLine($"Artist Name: {old.ArtistName} Real Name: {old.RealName} Age: {old.Age}"); } //(Optional) Display the Group Name of all groups that have members that are not from New York City //(Optional) Display the artist names of all members of the group 'Wu-Tang Clan' }
public static void Main(string[] args) { //Collections to work with List <Artist> Artists = MusicStore.GetData().AllArtists; List <Group> Groups = MusicStore.GetData().AllGroups; //======================================================== //Solve all of the prompts below using various LINQ queries //======================================================== //There is only one artist in this collection from Mount Vernon, what is their name and age? var VernArtist = Artists.Where(art => art.Hometown.Contains("Mount Vernon")) //Where grabs the artist the artist .Select(art => new { art.Age, art.ArtistName }); //Select grabs the artist att foreach (var artist in VernArtist) { Console.WriteLine("Artist: " + artist.ArtistName + " Age: " + artist.Age); } //Who is the youngest artist in our collection of artists? var youngest = Artists.OrderByDescending(art => art.Age).Last(); Console.WriteLine("Artist: " + youngest.ArtistName + " Age: " + youngest.Age); //Display all artists with 'William' somewhere in their real name var will = Artists.Where(art => art.RealName.Contains("William")) .Select(art => art.RealName); foreach (var artist in will) { Console.WriteLine(artist); } //Display the 3 oldest artist from Atlanta var atlanta = Artists.Where(art => art.Hometown == "Atlanta").OrderByDescending(art => art.Age).Take(3); foreach (var artist in atlanta) { Console.WriteLine("Artist: " + artist.ArtistName + " Age: " + artist.Age + " Hometown: " + artist.Hometown); } //(Optional) Display the Group Name of all groups that have members that are not from New York City //(Optional) Display the artist names of all members of the group 'Wu-Tang Clan' Console.WriteLine(Groups.Count); }
public static void Main(string[] args) { //Collections to work with List <Artist> Artists = MusicStore.GetData().AllArtists; List <Group> Groups = MusicStore.GetData().AllGroups; //======================================================== //Solve all of the prompts below using various LINQ queries //======================================================== //There is only one artist in this collection from Mount Vernon, what is their name and age? IEnumerable <Artist> myArtist = Artists.Where(x => x.Hometown == "Mount Vernon").ToList(); foreach (var artist in myArtist) { System.Console.WriteLine($"Real Name: {artist.RealName} Age: {artist.Age}"); } //Who is the youngest artist in our collection of artists? var youngArtist = Artists.OrderBy(x => x.Age).First(); System.Console.WriteLine($"The youngest artist is: {youngArtist.ArtistName} with an age of {youngArtist.Age}"); //Display all artists with 'William' somewhere in their real name var williams = Artists.Where(a => a.RealName.Contains("William")).Select(a => a.RealName); foreach (var william in williams) { Console.WriteLine(william); } //Display the 3 oldest artist from Atlanta var atlanta = Artists.Where(a => a.Hometown == "Atlanta").OrderByDescending(a => a.Age).Take(3); foreach (var artist in atlanta) { Console.WriteLine(artist.RealName + " is " + artist.Age + " years old and is from " + artist.Hometown); } //(Optional) Display the Group Name of all groups that have members that are not from New York City //(Optional) Display the artist names of all members of the group 'Wu-Tang Clan' Console.WriteLine(Groups.Count); }
public static void Main(string[] args) { //Collections to work with List <Artist> Artists = MusicStore.GetData().AllArtists; List <Group> Groups = MusicStore.GetData().AllGroups; //======================================================== //Solve all of the prompts below using various LINQ queries //======================================================== //There is only one artist in this collection from Mount Vernon, what is their name and age? Artist a1 = Artists.FirstOrDefault(art => art.Hometown == "Mount Vernon"); Console.WriteLine(a1.ArtistName + " : " + a1.Age); //Who is the youngest artist in our collection of artists? Artist a2 = (Artist)Artists.OrderBy(art => art.Age).First(); Console.WriteLine(a2.ArtistName + " : " + a2.Age); //Display all artists with 'William' somewhere in their real name List <Artist> a3 = Artists.Where(art => art.ArtistName.Contains("William") || art.RealName.Contains("William")).ToList(); foreach (Artist afor in a3) { Console.WriteLine(afor.ArtistName + " : " + afor.Age); } //Display the 3 oldest artist from Atlanta List <Artist> a4 = Artists .OrderBy(art => art.Age) .Where(art => art.Hometown == "Atlanta") .Take(3).ToList(); foreach (Artist afor in a4) { Console.WriteLine(afor.ArtistName + " : " + afor.Age); } //(Optional) Display the Group Name of all groups that have members that are not from New York City //(Optional) Display the artist names of all members of the group 'Wu-Tang Clan' Console.WriteLine(Groups.Count); }
public static void Main(string[] args) { //Collections to work with List <Artist> Artists = MusicStore.GetData().AllArtists; List <Group> Groups = MusicStore.GetData().AllGroups; //======================================================== //Solve all of the prompts below using various LINQ queries //======================================================== //There is only one artist in this collection from Mount Vernon, what is their name and age? Artist mtVerArtist = Artists.FirstOrDefault(who => who.Hometown == "Mount Vernon"); // Console.WriteLine(mtVerArtist.ArtistName + " " + mtVerArtist.Age); //Who is the youngest artist in our collection of artists? Artist youngest = Artists.FirstOrDefault(young => young.Age == Artists.Min(y => y.Age)); // Console.WriteLine(youngest.ArtistName); //Display all artists with 'William' somewhere in their real name List <Artist> williamArtists = Artists.Where(name => name.RealName.Contains("William")).ToList(); // PrintEach(williamArtists); // //Display the 3 oldest artists from Atlanta // List<Artist> atlArtists = Artists.Where(loc => loc.Hometown == "Atlanta" && loc.Age.OrderByDecending == ).ToList(); // PrintEach(atlArtists); IEnumerable <Artist> atlArtists = Artists .Where(loc => loc.Hometown == "Atlanta") .OrderByDescending(a => a.Age) .Take(3); PrintEach(atlArtists); //(Optional) Display the Group Name of all groups that have members that are not from New York City //(Optional) Display the artist names of all members of the group 'Wu-Tang Clan' // Console.WriteLine(Groups.Count); }
public static void Main(string[] args) { //Collections to work with List <Artist> Artists = MusicStore.GetData().AllArtists; List <Group> Groups = MusicStore.GetData().AllGroups; //======================================================== //Solve all of the prompts below using various LINQ queries //======================================================== //There is only one artist in this collection from Mount Vernon, what is their name and age? Artist mtVernon = Artists.FirstOrDefault(artage => artage.Hometown == "Mount Vernon"); System.Console.WriteLine($"Name: {mtVernon.RealName}, Age: {mtVernon.Age}"); //Who is the youngest artist in our collection of artists? Artist youngone = Artists.OrderBy(a => a.Age).First(); System.Console.WriteLine($"Name: {youngone.RealName}, Age: {youngone.Age} "); //Display all artists with 'William' somewhere in their real name List <Artist> realWilliam = Artists.Where(a => a.RealName.Contains("Wil")).ToList(); foreach (Artist wil in realWilliam) { System.Console.WriteLine($"{wil.RealName}"); } //Display the 3 oldest artist from Atlanta List <Artist> oldestAtlanta = Artists.Where(h => h.Hometown == "Atlanta").OrderByDescending(a => a.Age).Take(3).ToList(); foreach (Artist age in oldestAtlanta) { System.Console.WriteLine($"Name: {age.ArtistName}, Age: {age.Age}"); } //(Optional) Display the Group Name of all groups that have members that are not from New York City //(Optional) Display the artist names of all members of the group 'Wu-Tang Clan' Console.WriteLine(Groups.Count); }
public static void Main(string[] args) { //Collections to work with List <Artist> Artists = MusicStore.GetData().AllArtists; List <Group> Groups = MusicStore.GetData().AllGroups; //======================================================== //Solve all of the prompts below using various LINQ queries //======================================================== //There is only one artist in this collection from Mount Vernon, what is their name and age? // Artist MtVernon = Artists.FirstOrDefault(loc => loc.Hometown == "Mount Vernon"); // System.Console.WriteLine(MtVernon.RealName); //Who is the youngest artist in our collection of artists? Artist Youngest = Artists.OrderBy(age => age.Age).FirstOrDefault(); // System.Console.WriteLine(Youngest.ArtistName + " is the youngest at age " + Youngest.Age); //Display all artists with 'William' somewhere in their real name IEnumerable <Artist> Williams = from temp in Artists.Where(will => will.RealName.Contains("William")) select temp; foreach (var william in Williams) { System.Console.WriteLine(william.RealName); } //Display the 3 oldest artist from Atlanta IEnumerable <Artist> Oldest = Artists.OrderByDescending(age => age.Age).Take(3); foreach (var i in Oldest) { System.Console.WriteLine(i.ArtistName + " " + i.Age); } //(Optional) Display the Group Name of all groups that have members that are not from New York City //(Optional) Display the artist names of all members of the group 'Wu-Tang Clan' // Console.WriteLine(Groups.Count); }
public static void Main(string[] args) { //Collections to work with List <Artist> Artists = MusicStore.GetData().AllArtists; List <Group> Groups = MusicStore.GetData().AllGroups; //======================================================== //Solve all of the prompts below using various LINQ queries //======================================================== //There is only one artist in this collection from Mount Vernon, what is their name and age? System.Console.WriteLine("That Guy From Mount Vernon"); IEnumerable <Artist> thatGuyFromMtVernon = Artists.Where(a => a.Hometown == "Mount Vernon"); foreach (var a in thatGuyFromMtVernon) { System.Console.WriteLine("Name: " + a.ArtistName + " Age: " + a.Age); } //Who is the youngest artist in our collection of artists? // int yAge = Artists.Min(artist => artist.Age); System.Console.WriteLine("Youngest Gun"); IEnumerable <Artist> youngestArtist = Artists.Where(artist => artist.Age == Artists.Min(a => a.Age)); foreach (var a in youngestArtist) { System.Console.WriteLine("Name: " + a.ArtistName + " Age: " + a.Age); } //Display all artists with 'William' somewhere in their real name System.Console.WriteLine("Billys"); IEnumerable <Artist> billys = Artists.Where(artist => artist.RealName.Contains("William")); foreach (var a in billys) { System.Console.WriteLine("Name: " + a.ArtistName + " Age: " + a.Age); } // //Display the 3 oldest artist from Atlanta System.Console.WriteLine("Fossils"); IEnumerable <Artist> fossils = Artists.OrderByDescending(artist => artist.Age) .Take(3); foreach (var a in fossils) { System.Console.WriteLine("Name: " + a.ArtistName + " Age: " + a.Age); } //(Optional) Display the Group Name of all groups that have members that are not from New York City System.Console.WriteLine("Non New Yorkers"); IEnumerable <string> notApples = Artists.Where(artist => artist.Hometown != "New York City") .Join(Groups, artist => artist.GroupId, group => group.Id, (artists, group) => { return(group.GroupName); }).Distinct().ToArray(); foreach (var member in notApples) { System.Console.WriteLine(member); } //(Optional) Display the artist names of all members of the group 'Wu-Tang Clan' System.Console.WriteLine("Wu-Tang Clan"); IEnumerable <string> wuTangClan = Groups .Where(group => group.GroupName == "Wu-Tang Clan") .Join(Artists, group => group.Id, artist => artist.GroupId, (group, artist) => { return(artist.ArtistName + " " + artist.RealName + " " + group.GroupName); }); foreach (var member in wuTangClan) { System.Console.WriteLine(member); } // Console.WriteLine(Groups.Count); }
public static void Main(string[] args) { //Collections to work with List <Artist> Artists = MusicStore.GetData().AllArtists; List <Group> Groups = MusicStore.GetData().AllGroups; //======================================================== //Solve all of the prompts below using various LINQ queries //======================================================== //There is only one artist in this collection from Mount Vernon, what is their name and age? // (the same as the next line) List<Artist> FromMtVernon = Artists.Where(artist => artist.Hometown == "Mount Vernon").ToList(); // IEnumerable<Artist> FromMtVernon = Artists.Where(artist => artist.Hometown == "Mount Vernon"); // Console.WriteLine(FromMtVernon); // PrintItems(FromMtVernon); // Artist FromMt = Artists.FirstOrDefault(art => art.Hometown =="Mount Vernon"); // Console.WriteLine(FromMt); // FromMtVernon.Add //Who is the youngest artist in our collection of artists? // int youngestValue = Artists.Min(a => a.Age); // Artist youngest = Artists.FirstOrDefault(artist => artist.Age == Artists.Min(a => a.Age)); // Console.WriteLine(youngest.Age); //.Where(artist => artist.Age == Artists.Min(artist => artist.Age)); //Display all artists with 'William' somewhere in their real name // IEnumerable<Artist> NamedWill = Artists.Where(artist => artist.RealName.Contains("William")); // Console.WriteLine("Hello"); // PrintItems(NamedWill); //Display the 3 oldest artist from Atlanta // IEnumerable<Artist> Oldest = Artists.Where(artist => artist.Hometown == "Atlanta").OrderByDescending(a => a.Age).Take(3); // foreach (var item in Oldest) // { // Console.WriteLine(item.ArtistName); // } //(Optional) Display the Group Name of all groups that have members that are not from New York City // IEnumerable<Artist> notNewY = Artists.Where(artist => artist.Hometown != "New York City"); // foreach (var item in notNewY) // { // Console.WriteLine(item.ArtistName); // } //(Optional) Display the artist names of all members of the group 'Wu-Tang Clan' // Console.WriteLine(Groups.Count); // int GroupId = Artist.Where(args => a.) IEnumerable <Group> Wu = Groups.Where(artist => artist.GroupName == "Wu-Tang-Clan"); foreach (var item in Wu) { Console.WriteLine(item.Members); } // int youngestValue = Artists.Min(a => a.Age); // Artist youngest = Artists.FirstOrDefault(artist => artist.Age == Artists.Min(a => a.Age)); }
public static void Main(string[] args) { //Collections to work with List <Artist> Artists = MusicStore.GetData().AllArtists; List <Group> Groups = MusicStore.GetData().AllGroups; //======================================================== //Solve all of the prompts below using various LINQ queries //======================================================== //There is only one artist in this collection from Mount Vernon, what is their name and age? Artist mountArtist = Artists.FirstOrDefault(art => art.Hometown == "Mount Vernon"); System.Console.WriteLine(mountArtist.ArtistName); System.Console.WriteLine(mountArtist.Age); System.Console.WriteLine("************************"); //Who is the youngest artist in our collection of artists? int youngestAge = Artists.Min(art => art.Age); Artist youngestArtist = Artists.FirstOrDefault(art => art.Age == youngestAge); System.Console.WriteLine(youngestArtist.ArtistName + " is " + youngestAge + " years old."); System.Console.WriteLine("************************"); //Display all artists with 'William' somewhere in their real name var allWilliam = Artists.Where(art => art.RealName.Contains("William")); foreach (var artist in allWilliam) { System.Console.WriteLine(artist.RealName); } System.Console.WriteLine("************************"); //Display the 3 oldest artist from Atlanta var atlArtists = Artists .Where(art => art.Hometown == "Atlanta") .OrderByDescending(art => art.Age) .Take(3); foreach (var artist in atlArtists) { System.Console.WriteLine(artist.ArtistName); } System.Console.WriteLine("************************"); //Display all groups with names less than 8 characters in length. var shortNames = Groups.Where(g => g.GroupName.Length < 8); foreach (var group in shortNames) { Console.WriteLine(group.GroupName); } Console.WriteLine("*************************************"); //(Optional) Display the Group Name of all groups that have members that are not from New York City var groupJoin = Groups .Join(Artists, (g => g.Id), (a => a.GroupId), (joinedGroup, joinedArtist) => { joinedGroup.Members.Add(joinedArtist); return(joinedGroup); }) .Distinct() .ToList(); var notNYC = groupJoin.Where(gj => gj.Members.Any(m => m.Hometown != "New York CIty")).ToList(); foreach (var group in notNYC) { System.Console.WriteLine(group.GroupName); } Console.WriteLine("*************************************"); //(Optional) Display the artist names of all members of the group 'Wu-Tang Clan' // Console.WriteLine(Groups.Count); var clanJoin = Artists .Join(Groups, (a => a.GroupId), (g => g.Id), (joinedArtist, joinedGroup) => { return(joinedArtist); }) .ToList(); var clanArtists = clanJoin.Where(cj => cj.Group.GroupName == "Wu-Tang Clan"); foreach (var artist in clanArtists) { System.Console.WriteLine(artist.ArtistName); } }
public static void Main(string[] args) { //Collections to work with List <Artist> Artists = MusicStore.GetData().AllArtists; List <Group> Groups = MusicStore.GetData().AllGroups; //======================================================== //Solve all of the prompts below using various LINQ queries //======================================================== //There is only one artist in this collection from Mount Vernon, what is their name and age? Artist firstOne = Artists.FirstOrDefault(); System.Console.WriteLine("#########################"); System.Console.WriteLine("Name " + firstOne.ArtistName); System.Console.WriteLine("Age " + firstOne.Age); //Who is the youngest artist in our collection of artists? List <Artist> youngest = Artists.OrderBy(a => a.Age).ToList(); System.Console.WriteLine("Name " + youngest.First().ArtistName); System.Console.WriteLine("Age" + youngest.First().Age); // Display all artists with 'William' somewhere in their real name List <Artist> williamList = Artists.Where(a => a.RealName.Contains("William")).ToList(); foreach (var w in williamList) { System.Console.WriteLine("William in name: " + w.RealName); } // Display all groups with name less than 8 characters in length. List <Group> nameList = Groups.Where(g => g.GroupName.Length < 8).ToList(); foreach (var name in nameList) { System.Console.WriteLine("name less than 8 characters: " + name.GroupName); } //Display the 3 oldest artist from Atlanta List <Artist> ageList = Artists.OrderByDescending(a => a.Age).Take(3).ToList(); foreach (var a in ageList) { System.Console.WriteLine("Three oldest " + a.Age); } //(Optional) Display the Group Name of all groups that have members that are not from New York City List <Group> groupList = Groups.Where(g => g.Members.TrueForAll(m => m.Hometown != "New York City")).ToList(); foreach (var g in groupList) { System.Console.WriteLine("Not from New York: " + g.GroupName); } //(Optional) Display the artist names of all members of the group 'Wu-Tang Clan' Group group = Groups.FirstOrDefault(g => g.GroupName == "Wu-Tang Clan"); foreach (var g in group.Members) { System.Console.WriteLine("Wu-Tang: " + g.ArtistName); } Console.WriteLine(Groups.Count); }
public static void Main(string[] args) { //Collections to work with List <Artist> Artists = MusicStore.GetData().AllArtists; List <Group> Groups = MusicStore.GetData().AllGroups; //======================================================== //Solve all of the prompts below using various LINQ queries //======================================================== //There is only one artist in this collection from Mount Vernon, what is their name and age? IEnumerable <Artist> justMtVernon = Artists.Where(resulta => resulta.Hometown == "Mount Vernon"); foreach (var a in justMtVernon) { Console.WriteLine(a.Age + " and " + a.ArtistName); } System.Console.WriteLine("\n++++++++++++++\n"); //Who is the youngest artist in our collection of artists? IEnumerable <Artist> youngest = Artists.OrderByDescending(resultb => resultb.Age); Artist myYoungest = youngest.Last(); System.Console.WriteLine(myYoungest.ArtistName + " and " + myYoungest.Age); System.Console.WriteLine("\n++++++++++++++\n"); //Display all artists with 'William' somewhere in their real name IEnumerable <Artist> justWilliam = Artists.Where(resultc => resultc.RealName.Contains("William")); foreach (var a in justWilliam) { Console.WriteLine(a.RealName); } System.Console.WriteLine("\n++++++++++++++\n"); //Display all groups with names less than 8 characters in length. IEnumerable <Group> eightChars = Groups.Where(resultf => resultf.GroupName.Length < 8); foreach (var b in eightChars) { System.Console.WriteLine(b.GroupName); } System.Console.WriteLine("\n++++++++++++++\n"); //Display the 3 oldest artist from Atlanta IEnumerable <Artist> oldAtlanta = Artists.Where(resultd => resultd.Hometown == "Atlanta"); IEnumerable <Artist> threeOldest = oldAtlanta.OrderByDescending(resulte => resulte.Age); int i = 0; foreach (var a in threeOldest) { if (i > 2) { break; } System.Console.WriteLine(a.ArtistName + " and " + a.Age + " and " + a.Hometown); i++; } System.Console.WriteLine("\n++++++++++++++\n"); //(Optional) Display the Group Name of all groups that have members that are not from New York City //(Optional) Display the artist names of all members of the group 'Wu-Tang Clan' int myGroupId = 0; IEnumerable <Group> wtc = Groups.Where(resultf => resultf.GroupName == "Wu-Tang Clan"); foreach (var w in wtc) { myGroupId = w.Id; } IEnumerable <Artist> wtcOnly = Artists.Where(resultg => resultg.GroupId == myGroupId); foreach (var a in wtcOnly) { System.Console.WriteLine(a.ArtistName); } System.Console.WriteLine("\n++++++++++++++\n"); // Console.WriteLine(Groups.Count); }