我有以下 LinQ 查詢 var CGTABLE = (from cg in DbContext.CGTABLE join tcg in DbContext.TCGTABLE on new { cg.CGroupId } equals new { tcg.CGroupId } where tcg.TId == TId select new { CGroupId = cg.CGroupId, CGroupCode = cg.CGroupCode, Description = cg.Description, C = cg.C, DisplayOrder = cg.DisplayOrder }).ToList(); CGTABLE = CGTABLE.OrderBy(g => g.DisplayOrder).ThenBy(g => g.C.OrderBy(c => c.CCode)).ToList();運(yùn)行良好，但它沒有通過使用 ThenBy 進(jìn)行第二次排序ThenBy(g => g.C.OrderBy(c => c.CCode)我錯(cuò)過了什么？Sample data for better understanding.Data in Tables2 1 2 4 31 4 5 2 13 3 1Should output after both outer and inner list ordered by1 1 2 3 42 1 2 4 53 1 3But Currently it is showing1 4 5 2 12 1 2 4 33 3 1
1 回答
阿波羅的戰(zhàn)車
TA貢獻(xiàn)1862條經(jīng)驗(yàn) 獲得超6個(gè)贊
您不想訂購主列表，我想您正在尋找一種在外部列表中訂購內(nèi)部列表的方法。所以下面的代碼會(huì)為你做：
var CGTABLE = (
from cg in DbContext.CGTABLE
join tcg in DbContext.TCGTABLE on new { cg.CGroupId } equals new { tcg.CGroupId }
where tcg.TId == TId
select new {
CGroupId = cg.CGroupId,
CGroupCode = cg.CGroupCode,
Description = cg.Description,
C = cg.C.OrderBy(x => x.CCode),
DisplayOrder = cg.DisplayOrder
}).ToList();
CGTABLE = CGTABLE.OrderBy(g => g.DisplayOrder).ToList();
- 1 回答
- 0 關(guān)注
- 226 瀏覽
添加回答
舉報(bào)
0/150
提交
取消