Skip to content
  • Home
  • About
  • No Access
  • Privacy Policy
Bits of .NET
Bits of .NET
  • Asp.Net Core
  • C#
  • SQL
  • JavaScript
  • CSS
  • About
  • ErcanOPAK.com
  • No Access
  • Privacy Policy

Bits of .NET

Daily micro-tips for C#, SQL, performance, and scalable backend engineering.

  • Asp.Net Core
  • C#
  • SQL
  • JavaScript
  • CSS
  • About
  • ErcanOPAK.com
  • No Access
  • Privacy Policy
C#

C#: Fix an IAsyncEnumerable That Silently Loads Everything Into Memory Because of One Accidental ToListAsync Call

- 04.10.26 - ErcanOPAK

🔧 The Await Foreach That Was Never Actually Streaming

An async-enumerable sequence is supposed to stream results one at a time, pulling and awaiting only what the consumer actually asks for – that is the entire reason to reach for it over a regular collection. Add a single call that materializes the whole sequence into a list anywhere before the real consumer gets to it, and every row loads into memory upfront instead, which defeats the one benefit the streaming method was written for in the first place. The code still compiles, still works on a small development dataset, and the regression only shows up as excess memory use or a timeout once it meets a production-sized result.

🔎 The Problem

public async IAsyncEnumerable<Order> GetOrdersAsync(
    [EnumeratorCancellation] CancellationToken ct = default)
{
    using var reader = await _db.ExecuteReaderAsync(ct);
    while (await reader.ReadAsync(ct))
    {
        yield return MapOrder(reader);
    }
}

// The caller only wants a count, and reaches for the obvious-looking API:
public async Task<int> CountOrdersAsync()
{
    var orders = await GetOrdersAsync().ToListAsync();
    return orders.Count;
}

// Every single row now sits in memory as a materialized list before
// CountOrdersAsync even looks at the count - the streaming method
// never gets a chance to do what it was written for, because the
// list-building call drains it completely before returning control.

✅ Fix: Match the Call to What You Actually Need

  • Prefer the method that matches what you actually need – a counting method, an existence check, or a plain await-foreach with an incrementing counter – instead of reaching for a list-building call out of habit when all you need is a single derived value, not the whole collection.
  • Audit call sites that accept an async-enumerable parameter or return value for any list- or array-building call applied immediately afterward – that combination means the method signature promises streaming but the actual code path never streams at all.
  • When a method truly needs the entire collection in memory, say so directly in its own return type instead of accepting a streaming sequence and materializing it internally – that keeps the real cost visible at the call site rather than hidden one layer down.

⚠️ Why This Is Easy to Miss

  • A list-building call reads as the natural next step once a plain await-foreach does not fit cleanly into a chained, LINQ-style expression, so it looks like an idiomatic choice rather than a deliberate decision to give up on streaming.
  • A small development or staging dataset loads into memory in milliseconds either way, so the real difference between streaming and loading everything upfront only becomes visible once the sequence reaches production scale.

An async-enumerable sequence is a promise to go row by row – one eager list-building call anywhere in the chain cashes that promise in for the full balance, all at once.

— C# Best Practice

Related posts:

C# Dictionary Lookups Are Slower Than Expected

C# Dictionary Lookups Are Slower Than Expected

C#: Use Properties for Encapsulation

C#: Use Properties for Encapsulation

C#: Fix a Stackalloc Buffer That Silently Corrupts Memory the Moment It Escapes the Method That Crea...

C#: Fix a Stackalloc Buffer That Silently Corrupts Memory the Moment It Escapes the Method That Crea...

Views: 10

Post navigation

The AI Prompt That Turns a Plant Tag’s Care Instructions Into a Personalized Weekly Watering and Light Schedule
ASP.NET Core: Fix a gRPC Service That Silently Truncates Large Responses Because of a Default Message Size Limit

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

November 2026
M T W T F S S
 1
2345678
9101112131415
16171819202122
23242526272829
30  
« Oct    

Most Viewed Posts

  • How to make theater mode the default for Youtube (1,068)
  • Get the User Name and Domain Name from an Email Address in SQL (990)
  • How to add default value for Entity Framework migrations for DateTime and Bool (986)
  • Get the First and Last Word from a String or Sentence in SQL (865)
  • How to select distinct rows in a datatable in C# (859)
  • How to enable, disable and check if Service Broker is enabled on a database in SQL Server (661)
  • Add Constraint to SQL Table to ensure email contains @ (619)
  • Average of all values in a column that are not zero in SQL (577)
  • How to use Map Mode for Vertical Scroll Mode in Visual Studio (553)
  • Find numbers with more than two decimal places in SQL (481)

Recent Posts

  • Network Speed Monitor Windows Application v2.5.1
  • Ağ Hızı İzleyici Windows Uygulaması v2.5.1
  • How to make theater mode the default for Youtube
  • The AI Prompt That Audits a Function for Thread-Safety Gaps
  • Ajax: Fix a Fetch Request Caching a Response Despite No-Store
  • WordPress: Fix a Navigation Block Losing Submenu Items After Sync
  • Visual Studio: Fix CodeLens Reference Counts Stuck at Stale Numbers
  • C#: Fix a UTF-8 String Literal Behaving Differently in a Switch
  • Photoshop: Fix a Liquify Mesh Snapping Back on a Smart Object
  • The AI Prompt That Turns a Crash Dump Into a Short Repro Script

Most Viewed Posts

  • How to make theater mode the default for Youtube (1,068)
  • Get the User Name and Domain Name from an Email Address in SQL (990)
  • How to add default value for Entity Framework migrations for DateTime and Bool (986)
  • Get the First and Last Word from a String or Sentence in SQL (865)
  • How to select distinct rows in a datatable in C# (859)

Recent Posts

  • Network Speed Monitor Windows Application v2.5.1
  • Ağ Hızı İzleyici Windows Uygulaması v2.5.1
  • How to make theater mode the default for Youtube
  • The AI Prompt That Audits a Function for Thread-Safety Gaps
  • Ajax: Fix a Fetch Request Caching a Response Despite No-Store

Social

  • ErcanOPAK.com
  • GoodReads
  • LetterBoxD
  • Linkedin
  • The Blog
  • Twitter
© 2026 Bits of .NET | Built with Xblog Plus free WordPress theme by wpthemespace.com