LINQ——语言级集成查询入门指南(1)(2)

SELECT c.CompanyName, c.ContactName, c.City
FROM Customers c
WHERE c.City != 'Berlin'
ORDER BY c.ContactName

var customerNotInBerlin =
   from c in GetCustomers()
   where c.City != "Berlin"
   orderby c.ContactName
   select c;

using System;
using System.Collections.Generic;
using System.Linq;

namespace LINQIntro
{
   class Customer
   {
      public string CustomerName { get; set; }
      public string ContactName { get; set; }
      public string City { get; set; }
      public override string ToString()
      {
         return this.CustomerName + ", " +
            this.ContactName + ", " + this.City;
      }
   }

   class Program
   {
      static void Main(string[] args)
      {
         Program.ShowCustomers();
      }

      public static void ShowCustomers()
      {
         //使用对象初始化程序建立一列customer
         List customers = new List {
            new Customer { CustomerName = "Alfreds Futterkiste",
               ContactName = "Maria Anders", City = "Berlin"},
            new Customer { CustomerName =
               "Ana Trujillo Emparedados y helados",
               ContactName = "Ana Trujillo",
               City = "México D.F."},
            new Customer { CustomerName =
               "Antonio Moreno Taquería",
               ContactName = "Antonio Moreno",
               City = "México D.F."},
            new Customer { CustomerName = "Around the Horn",
               ContactName = "Thomas Hardy",
               City = "London"},
            new Customer { CustomerName = "Berglunds snabbköp",
               ContactName = "Christina Berglund",
               City = "Luleå"}};

          //查询customer列，指定显示字段
            var customer =
            from c in customers
            where c.City != "Berlin"
            orderby c.ContactName
            select c;

         //在终端显示选择的记录
         foreach (var row in customer)
         {
            Console.WriteLine(row);
         }
         Console.ReadLine();
      }
   }
}