将LINQ查询语句转换为Lambda表达式

var result = db.Work_Process .GroupJoin(db.Base_Station, A => A.StationNo, B => B.StationNo, (A, AB) => new { A, B = AB.DefaultIfEmpty() }) .GroupBy(x => new { x.A.StationNo, x.B.FirstOrDefault().SortIndex }) .OrderBy(x => x.Key.SortIndex) .Select(g => new { StationNo = g.Key.StationNo, Count = g.Count() });