使用Include时，阻止实体框架添加ORDER BY [英] Prevent Entity Framework adding ORDER BY when using Include

问题描述

我们有一个类似于以下内容的查询：

We have a query similar to the following:

from x in db.Table.Include(x => x.Parent)
                  .Include(x => x.Parent.Relation)
                  .Include(x => x.Relation)
                  .Include(x => x.Children)
where /* some query */
select x

问题是当添加 .Include（x => x.Children），实体框架添加到 ORDER BY 生成的SQL导致查询需要很长时间才能执行，如下所示：

The problem is that when adding .Include(x => x.Children), the ORDER BY statement that Entity Framework adds to the generated SQL causes the query to take a long time to execute - something like the below:

ORDER BY [Project2].[Id1] ASC, [Project2].[Id2] ASC, [Project2].[Id] ASC, [Project2].[C4] ASC

将orderby添加到linq查询也没有帮助，除了添加一个额外的列进行排序之外，它不会影响上述语句。

Adding orderby to the linq query doesn't help either, it doesn't affect the statement above other than adding an additional column to sort by.

推荐答案

显然，这是EF在内部以后轻松创建结果对象。您不能通过指令删除订单。

Apparently, it's something that EF does internally to ease the creation of resulting objects afterwards. You can't remove the order by instruction.

这篇关于使用Include时，阻止实体框架添加ORDER BY的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！