C# linq group by

好久不用，忘了 记一下

//get data from db 
List<ModelClass> source = new List<ModelClass>();
//单一条件分组
var sc1 = from sf in source
          group sf by sf.Name;

//多个条件分组
var sc2 = from sf in source
          group sf by new { sf.Name,sf.Price,sf.Amount}
          into g
          select new 
          { 
          		Name= g.Key.Name,
          		Price= g.Sum(p=>p.Price),
          		Amount = g.Sum(p=>p.Amount)
          };

//多个条件分组，并返回新的对象
var sc3 = from sf in source
          group sf by new { sf.Name }
          into g
          //select new { Name = g.Key.Name, Price = g.Sum(p => p.Price), Amount = g.Sum(p => p.Amount) };
          select new ModelClass() 
          { 
              Name = g.Key.Name,
              Price =g.Sum(p=>p.Price),
              Number = g.Sum(p=>p.Number),
          };
		};                                          

var cls = from x in db.TableNames.Select(x => x.type).Distinct().ToList()
	      select new {  account  = x?.Trim() 			

var cls = from x in db.TableNames.Select(x=>x.Type).Distinct().ToList()
		  group x by new {x}
		  into g 
		  select new {account=g.Key};