How do you stream large results without high memory usage?

Use DataReader and process rows as they arrive.

Avoid buffering entire datasets. Combine with IAsyncEnumerable to stream to clients (e.g., ASP.NET Core) and apply pagination where possible.