sql语句帮我换成LInq 在线等 不知道Linq 的 Group by 怎么用

[qq_35754187]

select
count(b.WaybillID) as waybillCount,
sum(b.Weight) as weightCount,
a.InOrderID,
a.OrderNo,
c.CustomerID,
c.CustomerName,
a.Completed,
a.CompletedTime,
a.CreatedBy,
a.CreatedDate,
a.CreatedByName,
a.ModifiedBy,
a.ModifiedDate,
a.ModifiedByName
from bus_inorder as a
INNER JOIN base_customer as c on a.CustomerID=c.CustomerID
LEFT join bus_waybill as b on a.InOrderID=b.InOrderID
where a.CompanyID='935396977267576832'
group by
a.InOrderID,
a.OrderNo,
c.CustomerID,
c.CustomerName,
a.Completed,
a.CompletedTime,
a.CreatedBy,
a.CreatedDate,
a.CreatedByName,
a.ModifiedBy,
a.ModifiedDate,
a.ModifiedByName

[圣殿骑士18]

http://www.cnblogs.com/han1982/p/4138163.html

[threenewbee]

提问以前，请把你的问题简化，只保留必要的字段。为了回答你的问题，难道还要人家帮你敲一个完整的么？