如何在实体框架中包含排序的导航属性 [英] How to include sorted navigation properties with Entity Framework

问题描述

我有一个实体 A，里面有一个 B 的集合.我用 _entity.A.Include(a => a.B)

I have an entity A with a collection of B inside. I load them with a _entity.A.Include(a => a.B)

现在我想将 B 放入 A 中，按自定义 OrderBy 排序.我试过 _entity.A.Include(a => a.B.OrderBy(o => o.Version) 但我得到一个:

Now I want to have the B's into A sorted by a custom OrderBy. I tried _entity.A.Include(a => a.B.OrderBy(o => o.Version) but I get a :

包含路径表达式必须引用在类型上定义的导航属性.对引用导航属性使用虚线路径，对集合导航属性使用 Select 运算符.

The Include path expression must refer to a navigation property defined on the type. Use dotted paths for reference navigation properties and the Select operator for collection navigation properties.

关于如何实现这一点的任何想法?

Any ideas on how to accomplish this?

谢谢.

版本是一个整数.

推荐答案

我觉得这种情况你可以试试:

I think in this case you can try:

var list = _entity.A.Include("B").ToList();
list.ForEach(m => m.B = m.B.OrderBy(o => o.Version));

或:

_entity.A.Include("B").Select(m => new A {
        //some props,
        B = m.B.OrderBy(o => o.Version)
        });

这篇关于如何在实体框架中包含排序的导航属性的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！