.NET LINQ基本查詢操作

獲取數據源

 queryAllCustomers =  cust  customers
                         cust;

• 篩選

 queryLondonCustomers =  cust  customers
                            cust.City == 
                            cust;

 cust.City== && cust.Name == 

 cust.City ==  || cust.City == 

• 排序

 queryLondonCustomers3 = 
     cust  customers
     cust.City == 
     cust.Name 
     cust;

• 分組

 queryCustomersByCity =
       cust  customers
       cust  cust.City;
   ( customerGroup  queryCustomersByCity)
  {
      Console.WriteLine(customerGroup.Key);
       (Customer customer  customerGroup)
      {
          Console.WriteLine(, customer.Name);
      }
  }

 custQuery =
     cust  customers
     cust  cust.City  custGroup
     custGroup.Count() > 2
     custGroup.Key
     custGroup;

• 聯接

 innerJoinQuery =
     cust  customers
     dist  distributors  cust.City  dist.City
      { CustomerName = cust.Name, DistributorName = dist.Name };

• 選擇