我们有一个拥有811处房产的庞大实体.

我们在运行时动态生成视图,并成功完成.

我们通过一个简单的查询来测试所有记录和列.

通过反复试验,我们发现如果属性计数小于775,则查询不会返回任何问题.如果>=755它会导致AccessViolation异常或StackOverflow异常,例如:

An unhandled exception of type 'System.StackOverflowException' occurred in Microsoft.EntityFramework.dll

我们似乎已经达到了实体大小的上限.由于异常似乎来自EntityFramework核心,因此很难进一步调试.

这是一个已知的限制吗?我们可以做些什么来解决它吗?

Exception details: Exception details

EDIT

底层数据库是SQL,下面是查询(列名经过编辑,因为这是公司内部)

[18:18:06 INF] Executed DbCommand (112ms) [Parameters=[@__TypedProperty_1='?' (DbType = Int32), @__TypedProperty_0='?' (DbType = Int32)], CommandType='"Text"', CommandTimeout='30']
SELECT TOP(@__TypedProperty_1) [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...], [t].[column_...]
FROM (
    SELECT TOP(@__TypedProperty_0) [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...], [p].[column_...]
    FROM [dbo].[table_...] AS [p]
    ORDER BY [p].[column_...]
) AS [t]
ORDER BY [t].[column_...]
An unhandled exception of type 'System.StackOverflowException' occurred in Microsoft.EntityFrameworkCore.dll

推荐答案

我通过在我们的DbContext中关闭更改跟踪来解决这个问题.

protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder)
{
    if (!optionsBuilder.IsConfigured)
    {
        optionsBuilder
            ...
            .UseQueryTrackingBehavior(QueryTrackingBehavior.NoTracking);
    }
}

我们的端点无论如何都是只读的.

Csharp相关问答推荐

如何将两个查询结果组合在C#ASP.NET MHC控制器中

Regex在c#中完全匹配

为什么总输出就像12.3没有一分一样?

使用C#中的SDK在Microsoft Graph API上使用SubscribedSkus的问题

如何注册接口类型,类型<>

在具有不同属性名称的两个类之间创建关系

TeamsBot SendActivityActivityTypes与ActivityTypes同步.键入不再起作用

在C#中,将两个哈希集连接在一起的时间复杂度是多少?

从另一个不同 struct 的数组创建Newtonsoft.Json.Linq.J数组

依赖项注入、工厂方法和处置困境

基于C#和ANGING的SignalR实时聊天流媒体应用

如何在Akka.NET中重新启动执行元时清除邮箱

为什么C#/MSBuild会自发地为不同的项目使用不同的输出路径?

try 创建一个C#程序,该程序使用自动实现的属性、覆盖ToString()并使用子类

仅在ASP.NETCore应用程序中的附加单独端口上公开一组终结点

将两个for循环更改为一条LINQ语句

为什么连接到Google OAuth2后,结果.Credential为空?

Xamarin Forms应用程序中登录页面的用户名和密码编辑文本之间不需要的空格

项目参考和方法签名问题

如何使ExecuteAsync异步运行