Out-of-Process Queries
IQueryable, query providers, SQL translation, where queries run, N+1, streaming
In-process data lives in your application's memory (a List), so LINQ to Objects can run your lambdas directly as compiled delegates. Out-of-process data lives somewhere else: a SQL database, Cosmos DB, MongoDB, an OData or search…