Question

C#LINQ的代码转换成一般的表达式

var queryResults =
from c in customers
group c by c.Region into cg
select new { TotalSales = cg.Sum(c => c.Sales), Region = cg.Key }
customers是一个类的实例，Region是这个类的属性

求转化成一般的表达式

Answer 1

select Region,Sum(Sales) from customers group by Region

Answer 2

SELECT SUM(Sales) AS TotalSales,Region FROM Customers GROUP BY Region