我有这个答案实体框架 OrderBy“CASE WHEN”但这只能处理两个选项
var p = ctx.People.OrderBy(p => (p.IsQualityNetwork == 1 || p.IsEmployee == 1) ? 0 : 1)
.ThenBy(p => p.Name);
我有一个文本字段,希望行按特定顺序显示。在sql中我会这样做:
ORDER BY CASE when name = "ca" then 1
when name = "po" then 2
when name = "pe" then 3
when name = "ps" then 4
when name = "st" then 5
when name = "mu" then 6
END
创建一个排序顺序的地图怎么样?
var sortOrder = new Dictionary<string,int>
{
{ "ca", 1 },
{ "po", 2 },
{ "pe", 3 },
{ "ps", 4 },
{ "st", 5 },
{ "mu", 6 }
};
var defaultOrder = sortOrder.Max(x => x.Value) + 1;
var sortedPeople = ctx
.People
.AsEnumerable()
.OrderBy(p => (p.IsQualityNetwork == 1 || p.IsEmployee == 1) ? 0 : 1)
.ThenBy(p => sortOrder.TryGetValue(p.Name, out var order) ? order : defaultOrder);
本文内容由网友自发贡献,版权归原作者所有,本站不承担相应法律责任。如您发现有涉嫌抄袭侵权的内容,请联系:hwhale#tublm.com(使用前将#替换为@)