c# - Which LINQ statements force Entity Framework to return from the DB?

Question

I know of several LINQ statements that will cause EF to evaluate and return results form the DB to memory. .ToList() is one. Does anyone have a comprehensive list of the statements that do this?

Not sure of...

.SingleOrDefault()
.Union()

EDIT: Wish I could accept all these answers. Great info from everyone!

Answer 1

It's a long list. They boil down to

Aggregate
All<TSource>
Any
Average
Contains
Count
ElementAt<TSource>
ElementAtOrDefault<TSource>
Empty<TResult>
First
FirstOrDefault
Last
LastOrDefault
LongCount
Max
Min
SequenceEqual
Single
SingleOrDefault
Sum
ToArray<TSource>
ToDictionary
ToList<TSource>
ToLookup

The rest are either Deferred Streaming Execution or Deferred Non-Streaming Execution.

In light of your question, SingleOrDefault() is Immediate Execution and Union() is Deferred Streaming Execution.