Welcome to the Lounge

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

string[] strings = 
{
    "A penny saved is a penny earned.",
    "The early bird catches the worm.",
    "The pen is mightier than the sword." 
};

string vowels = "aeiou";

List<string> vowelstartwords = String.Join(" ", strings)
        .Split(' ')
        .Distinct()
        .Where(word => vowels.Contains(Char.ToLower(word[0])))
        .ToList();

char[] vowels = { 'a', 'e', 'i', 'o', 'u' };

IEnumerable<string> vowelStartWords = strings
    .SelectMany(sentence => sentence.Split(' '))
    .Where(word => Array.IndexOf(vowels, char.ToLower(word[0])) != -1)
;

Console.WriteLine(
    string.Join(
        "\n",
        strings.SelectMany(sentence => sentence.Split(' '))
            .Where(word => Array.IndexOf(vowels, char.ToLower(word[0])) != -1)
            .Select(vowelWord => $"\"{vowelWord}\" starts with a vowel")))
;