Welcome to the Lounge

Pete O'Hanlon wrote:

So how have you been solving this in the past? Multiple queries chained together?

Pete O'Hanlon wrote:

Just wait until you start using "into[^]".

var categoryRanks = (from gs in geekSkills
  where (gs.ProfileId == profile.Id)
  join s in skills on gs.SkillId equals s.Id
  select new { Level = gs.Level, CategoryId = s.CategoryId } into gss
  join c in categories on gss.CategoryId equals c.Id
  select new { Level = gss.Level, Name = c.Name } into gssc
  group gssc by new { gssc.Name, gssc.Level } into g
  select new SkillLevelBySkillByCategory() { 
    SkillLevel = g.Key.Level, 
    SkillLevelCount = g.Count(x => x.Level == g.Key.Level), 
    Name = g.Key.Name });