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 });

var categoryRanks = from s in profile.geekSkills
   group s by new {Level = s.Level, Name = s.Category.Name} into g
   select new SkillLevelBySkillByCategory() {
   SkillLevel = g.Key.Level,
   SkillLevelCount = g.Count(x => x.Level == g.Key.Level),
   Name = g.Key.Name };

var categoryRanks = from s in profile.geekSkills
  let sl = new {Level = s.Level, Name = s.Category.Name}
  group sl by sl  into g
  select new SkillLevelBySkillByCategory() {
  SkillLevel = g.Key.Level,
  SkillLevelCount = g.Count(x => x.Level == g.Key.Level),
  Name = g.Key.Name };

James Curran wrote:

Now, if your table have appropriately assigned foreign keys,

Marc Clifton wrote:

They do, but I haven't set up my models yet with EntityRef and EntitySet.

var a = strings.SelectMany(x => x.Split(' ')).Select(x => x.ToLower()).Where(x => x[0] == 'a' || x[0] == 'e' || x[0] == 'i' || x[0] == 'o' || x[0] == 'u');

Rob Philpott wrote:

Is there anything you can do in one syntax that you can't in the other?

T record = mappedRecords[typeof(T)].Cast<T>().Where(r => r.Row == row).Single();

from T mappedRecord in mappedRecord[typeof(T)]
...

T record = (from T mappedRecord in mappedRecords[typeof(T)]
            where mappedRecord.Row == row
            select mappedRecord).Single();

T record = mappedRecords[typeof(T)].Cast<T>().Single(r => r.Row == row);

Nicholas Marty wrote:

I think you're mistaking Linq with Linq to SQL.

OriginalGriff wrote:

I can't get my head round the Linq syntax, so I always use method chaining.

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 });

T record = mappedRecords[typeof(T)].Cast<T>().Where(r => r.Row == row).Single();