防止实体框架在使用 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)时，Entity Framework在生成的SQL中添加的ORDER BY语句导致查询需要很长时间才能执行 - 如下所示:

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

在 linq 查询中添加 orderby 也无济于事，除了添加一个额外的列来排序之外，它不会影响上面的语句.

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 在内部执行的操作，以简化之后生成的对象的创建.您不能删除 order by 指令.

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屋！