Skip to content

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
C#

C# Async Streams — Stop Loading Huge Lists Into Memory

- 15.12.25 - ErcanOPAK

If you return large datasets like this:

var data = await repository.GetAllAsync();

You already lost memory and latency.

✅ Stream Instead

await foreach (var item in repository.StreamAsync())
{
    Process(item);
}

Why this is life-saving

  • Near-zero memory footprint

  • Faster first byte

  • Perfect for logs, exports, ETL

Related posts:

DateTime.Now Breaks Distributed Logic

.NET Core JSON Serializer Pitfalls — Why Your Properties Don’t Serialize

Add default value to Devex Grid Columns in C#

Post Views: 6

Post navigation

Visual Studio “F5 Takes Forever” — IIS Express Cache
C# “Lock Contention” — Why lock(this) Breaks Apps

Leave a Reply Cancel reply

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

January 2026
M T W T F S S
 1234
567891011
12131415161718
19202122232425
262728293031  
« Dec    

Most Viewed Posts

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

Recent Posts

  • C# String Operations Hurt Performance
  • C# DateTime Bugs Appear Across Servers
  • C# LINQ Queries Allocate Too Much
  • SQL Deadlocks Appear Sporadically
  • SQL Queries Break After Schema Changes
  • .NET Core Logs Impact Performance
  • ASP.NET Core Startup Becomes Slower
  • Git Branches Linger Forever
  • Git History Becomes Hard to Read
  • Ajax Requests Succeed but Data Is Stale

Most Viewed Posts

  • Get the User Name and Domain Name from an Email Address in SQL (923)
  • How to add default value for Entity Framework migrations for DateTime and Bool (811)
  • Get the First and Last Word from a String or Sentence in SQL (808)
  • How to select distinct rows in a datatable in C# (784)
  • How to make theater mode the default for Youtube (659)

Recent Posts

  • C# String Operations Hurt Performance
  • C# DateTime Bugs Appear Across Servers
  • C# LINQ Queries Allocate Too Much
  • SQL Deadlocks Appear Sporadically
  • SQL Queries Break After Schema Changes

Social

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