Prevent Entity Framework adding ORDER BY when using Include(防止实体框架在使用 Include 时添加 ORDER BY)
问题描述
我们有一个类似于以下的查询:
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的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持编程学习网!
本文标题为:防止实体框架在使用 Include 时添加 ORDER BY
基础教程推荐
- SSE 浮点算术是否可重现? 2022-01-01
- c# Math.Sqrt 实现 2022-01-01
- 有没有办法忽略 2GB 文件上传的 maxRequestLength 限制? 2022-01-01
- MS Visual Studio .NET 的替代品 2022-01-01
- 将 XML 转换为通用列表 2022-01-01
- 如何激活MC67中的红灯 2022-01-01
- 如何在 IDE 中获取 Xamarin Studio C# 输出? 2022-01-01
- 将 Office 安装到 Windows 容器 (servercore:ltsc2019) 失败,错误代码为 17002 2022-01-01
- rabbitmq 的 REST API 2022-01-01
- 为什么Flurl.Http DownloadFileAsync/Http客户端GetAsync需要 2022-09-30