sql语句改写成LINQ语句

[tqd354]

C#代码如何将下面的sql语句改写成LINQ语句
SELECT
shopId
,shopName
,shopNo
COUNT（*） AS count
SUM（total） AS total
FROM
trn_shop
GROUP BY
shopId
,shopName
,shopNo
ORDER BY
total
数据源
List<string[]> dataList = new List<string[]>();

[娃都会打酱油了]

from shop in db.trn_shop
group shop by new {shopId = shopId,shopName = shopName,shopNo=shopNo} into g
select new {
shopId = g.Key.shopId,
shopName =g.Key.shopName ,
shopNo = g.Key.shopNo,
count = g.Count(),
total = g.Sum(x=>x.total)
}