SELECT AStationNoCOUNTAStationNo FROM Mesdatabase_6631dboWork_Process A LEFT JOIN Base_Station B ON AStationNo=BStationNo GROUP BY AStationNoBSortIndex ORDER BY BSortIndex把这个sql语句转成使用linq表达式

var result = from A in db.Work_Process join B in db.Base_Station on A.StationNo equals B.StationNo into AB from B in AB.DefaultIfEmpty() group A by new { A.StationNo, B.SortIndex } into g orderby g.Key.SortIndex select new { StationNo = g.Key.StationNo, Count = g.Count() };