/// <summary>
/// 点标记
/// </summary>
public void Show()
{
var list = new ProductList();
var products = list.GetProductList();
var customers = list.GetCustomerList();
var productFirstChars =
from p in products
select p.ProductName[0];
var customerFirstChars =
from c in customers
select c.CompanyName[0];
Console.WriteLine();
Console.WriteLine("Intersect_2 点标记");
//Numbers < 5:
var result = productFirstChars.Intersect(customerFirstChars).OrderBy(x => x);
Print(result);
}
/// <summary>
/// 查询表达式
/// </summary>
/// <param name="x"></param>
public void Show(int x)
{
var list = new ProductList();
var customers = list.GetCustomerList();
Console.WriteLine();
Console.WriteLine("GroupBy_Nested 查询表达式");
//n % 5
var result = (from w in customers
select new {
w.CompanyName, YearGroups = from o in w.Orders
group o by o.OrderDate.Year into yg
select new {
Year = yg.Key,
MonthGroups = from o in yg
group o by o.OrderDate.Month into mg
select new { Month = mg.Key, Orders = mg }
}
}).ToList();
Print(result);
}