c# linq 汇总

linq count 计数

var q =  
from p in db.Products  
group p by p.CategoryID into g  
select new {
     
g.Key,  
NumProducts = g.Count()  
}; 

linq中使用case when select中使用case when linq代码：

Products.Select(P => new
{
   
  ID = P.ProductID,
  Name = P.Name,
  Color = P.Color,
  Price = (P.Color == "Red" ? P.StandardCost : (P.Color == "Black" ? P.StandardCost + 10 : P.ListPrice))
})