Welcome to the Lounge

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

public static class EnumerableExtensions
{
    public static void ForEach<T>(this IEnumerable<T> source, Action<T> action)
    {
        if (source == null) throw new ArgumentNullException(nameof(source));
        if (action == null) throw new ArgumentNullException(nameof(action));
        
        foreach (T item in source)
        {
            action(item);
        }
    }
}

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

.Select(vowelWord => Console.WriteLine($"\"{vowelWord}\" starts with a vowel"))