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#: LINQ Performance Optimization Techniques

- 15.08.26 - ErcanOPAK

⚡ LINQ Performance = Fast Queries

LINQ can be slow. Performance optimization makes LINQ queries fast and efficient.

📝 Optimization Techniques

// 1. Use Any() instead of Count() > 0
bool hasItems = data.Any();  // Good
bool hasItems = data.Count() > 0;  // Bad

// 2. Filter Before Projection
var result = data
    .Where(x => x.IsActive)  // Filter first
    .Select(x => x.Name)      // Then project
    .ToList();

// 3. Use SelectMany instead of Nested Loops
var allItems = data.SelectMany(x => x.Items).ToList();

// 4. Use ToLookup for Grouped Access
var lookup = data.ToLookup(x => x.Category);
var electronics = lookup["Electronics"];

// 5. Use HashSet for Existence Checks
var ids = new HashSet(data.Select(x => x.Id));
bool exists = ids.Contains(id);  // O(1)

// 6. Use Parallel LINQ for Large Datasets
var result = data
    .AsParallel()
    .WithDegreeOfParallelism(Environment.ProcessorCount)
    .Where(x => x.IsActive)
    .Select(x => ProcessItem(x))
    .ToList();

🎯 Advanced Optimization

// 7. Avoid Multiple Enumerations
var data = GetData();
var count = data.Count();  // First enumeration
var first = data.First();  // Second enumeration - Bad!

// Good: Materialize once
var data = GetData().ToList();
var count = data.Count();
var first = data.First();

// 8. Use Compiled Queries (EF Core)
private static readonly Func> GetUserById =
    EF.CompileAsyncQuery((MyContext ctx, int id) =>
        ctx.Users.FirstOrDefault(u => u.Id == id));

// 9. Use Select for Projection
var names = users.Select(u => u.Name);  // Only names
var fullUsers = users.ToList();  // All data - Bad!

// 10. Use Index for Performance
var data = new List { 1, 2, 3, 4, 5 };
var result = data
    .Select((item, index) => new { item, index })
    .Where(x => x.item % 2 == 0)
    .Select(x => $"Item {x.index}: {x.item}")
    .ToList();

// 11. Use Chunk for Batch Processing
var chunks = data.Chunk(100);  // .NET 6+
foreach (var chunk in chunks)
{
    ProcessChunk(chunk);
}

// 12. Use Take/Skip for Pagination
var page = data
    .Skip(pageNumber * pageSize)
    .Take(pageSize)
    .ToList();

💡 LINQ Optimization Tips

  • Filter before projection
  • Use Any() instead of Count()
  • Avoid multiple enumerations
  • Use ToLookup for grouping
  • Use Parallel LINQ for large data

Optimized LINQ queries are essential for performance. They make your application faster and more scalable.

— Performance Architect

Related posts:

How to use SQL RAISEERROR() messages in C#

How to use SQL RAISEERROR() messages in C#

C#: Fix a Lazy Initialization That Silently Runs Its Factory Twice Because the Thread-Safety Mode Wa...

C#: Fix a Lazy Initialization That Silently Runs Its Factory Twice Because the Thread-Safety Mode Wa...

The Hidden Cost of record Types in Hot Paths

The Hidden Cost of record Types in Hot Paths

Views: 16

Post navigation

C#: Async/Await Best Practices for Web APIs
Visual Studio: Refactoring Tools for Clean Code

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