An exception occurred while iterating over the results of a query for context type EF core

preview_player
Показать описание

  1. Deep Dive Dotnet
Рекомендации по теме
An exception occurred 0:05:25

An exception occurred while iterating over the results of a query for context type EF core

fail: Microsoft.EntityFrameworkCore.Database.Command[20102] | 0:04:32

fail: Microsoft.EntityFrameworkCore.Database.Command[20102] | Fix error | ASP.NET CORE

Fix: Unable to 0:05:55

Fix: Unable to resolve service for type Duende.IdentityServer.Stores.IClientStore While attempting

Did you know 0:01:00

Did you know this in Python? #python #coding #programming

Advanced Error and 0:46:08

Advanced Error and Exception Handling in Power Automate Desktop - Complete Tutorial

Could not find 0:00:30

Could not find or load main class. Java program error caused by java.lang.classnotfoundException

python continue for 0:02:30

python continue for loop after exception

Paythan control low 0:03:08

Paythan control low statement

While Loop - 0:10:38

While Loop - Apex Programming Level 4 ⭐⭐⭐⭐

NCBC1047_M2_U1_L1_V3 0:13:26

NCBC1047_M2_U1_L1_V3

How To Avoid 0:09:10

How To Avoid Common Mistakes as a Java Beginner - Part 3

Fix lenovo laptop 0:02:23

Fix lenovo laptop key pressing automatically

PLEASE Learn These 0:42:28

PLEASE Learn These 10 Advanced Python Features

Set Mismatch | 0:07:04

Set Mismatch | Live Coding with Explanation | Leetcode - 645

Fail Fast Vs 0:06:10

Fail Fast Vs Fail Safe Iterators - Collection Framework

Let's build the 2:13:35

Let's build the GPT Tokenizer

Ethical Hacking Free 0:45:55

Ethical Hacking Free Course | TypeScript Bootcamp Part - 5

Graph Algorithms Crash 1:41:11

Graph Algorithms Crash Course (with Java)

Hadley Wickham | 0:28:28

Hadley Wickham | {purrr} 1.0: A complete and consistent set of tools for functions and vectors

Exception Groups and 0:21:37

Exception Groups and except: Irit Katriel

Iterating on Observability: 0:38:24

Iterating on Observability: Reproducing Production Errors in Isolation

UiPath Try Catch 0:23:32

UiPath Try Catch - Full Tutorial From Start to Finish

How do I 0:10:05

How do I iterate through two lists in parallel?

Python for Everybody 13:40:10

Python for Everybody - Full University Python Course

Комментарии
Автор

I am getting the exact exception in the title of your video, but I don't think it is the same error you described. The reason I say that the error does not occur while iterating through the first rows of data. I am using keyset pagination, and initially I tried page size of 200 records. What I found was that the code worked fine on the first page, but trying to iterate the second page would generate the above exception. If there was an invalid column name in the SQL Query generated by EF Core 8, then clearly the error would happen sooner, correct? Meaning, while processing the first row.

I do have quite a complex query being generated due to having quite a few Include() calls, but I looked over the SQL statement and ran it myself and it executed in about 23 seconds without errors.

johnnyvlee