How does LINQ behave when used inside asynchronous streaming pipelines?

LINQ is not inherently async-stream aware and requires explicit async extensions like IAsyncEnumerable.

Standard LINQ operates synchronously over IEnumerable/IQueryable. Async streaming requires IAsyncEnumerable and await foreach. Mixing synchronous LINQ with async pipelines leads to blocking calls or inefficient buffering. EF Core supports async LINQ via extensions but still executes queries in batches rather than true streaming.