صياغة الاستعلام مقابل صياغة الأساليب

using System;
using System.Linq;

public class Program
{
  public static void Main(string[] args)
  {
    string[] words = new string[] { "dog", "tiger", "ant", "eagle" };

    var result = words
      .Where(w => w.Length >= 4)
      .Select(w => w.ToUpper());

    foreach (string w in result) Console.WriteLine(w);
  }
}

using System;
using System.Linq;

public class Program
{
  public static void Main(string[] args)
  {
    string[] words = new string[] { "dog", "tiger", "ant", "eagle" };

    var query =
      from w in words
      where w.Length >= 4
      select w.ToUpper();

    foreach (string w in query) Console.WriteLine(w);
  }
}

using System;
using System.Linq;

public sealed class City
{
  public string Name;
  public int Pop;
  public City(string name, int pop) { Name = name; Pop = pop; }
}

public class Program
{
  public static void Main(string[] args)
  {
    City[] cities = new City[]
    {
      new City("Rome", 2873000),
      new City("Oslo", 634000),
      new City("Riga", 605000),
      new City("Rio", 6748000)
    };

    // Method
    var m = cities
      .Where(c => c.Pop >= 700000)
      .OrderBy(c => c.Name)
      .Select(c => c.Name);

    // Query
    var q =
      from c in cities
      where c.Pop >= 700000
      orderby c.Name ascending
      select c.Name;

    foreach (string name in m) Console.WriteLine(name);
    Console.WriteLine("---");
    foreach (string name in q) Console.WriteLine(name);
  }
}

using System;
using System.Linq;

public class Program
{
  public static void Main(string[] args)
  {
    int[] data = new int[] { 5, 3, 9, 1, 7, 2, 8 };

    // Query + method mix: query part, then Count() method
    var q =
      from n in data
      where n > 3
      select n;

    int howMany = q.Count(); // no query keyword for Count
    Console.WriteLine("Count >3 = " + howMany);

    // Paging usually uses method syntax
    var page = data.OrderBy(n => n).Skip(2).Take(3);
    foreach (int x in page) Console.WriteLine(x);
  }
}