terminal operator

A LINQ call such as ToList, First, Count or Sum that actually runs a deferred query and produces a result.

In more detail

It is the border crossing into memory: everything before it can be translated to SQL by EF Core, and everything after it runs in C#. Calling ToList too early fetches the whole table.

Related terms

Taught in

References