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#: Use LINQ to Query Collections

- 24.07.26 - ErcanOPAK

🔍 LINQ = Query Collections

Loops are messy. LINQ queries collections cleanly. Filter, sort, group, aggregate — all in one.

❌ Imperative Loops

var adults = new List();
foreach (var user in users)
{
    if (user.Age >= 18)
        adults.Add(user);
}

✅ LINQ Query

var adults = users
    .Where(u => u.Age >= 18)
    .ToList();

📝 LINQ Methods

var numbers = new List { 1, 2, 3, 4, 5, 6, 7, 8, 9, 10 };

// Filter
var evens = numbers.Where(n => n % 2 == 0);
var evensList = evens.ToList(); // [2, 4, 6, 8, 10]

// Select (project)
var doubled = numbers.Select(n => n * 2).ToList();

// Filter and select
var squaredEvens = numbers
    .Where(n => n % 2 == 0)
    .Select(n => n * n)
    .ToList(); // [4, 16, 36, 64, 100]

// Order
var sorted = numbers.OrderBy(n => n).ToList();
var sortedDesc = numbers.OrderByDescending(n => n).ToList();

// First/Last
var first = numbers.First();
var last = numbers.Last();
var firstEven = numbers.First(n => n % 2 == 0);
var maybeFirst = numbers.FirstOrDefault(n => n > 10);

// Aggregate
var sum = numbers.Sum();
var avg = numbers.Average();
var min = numbers.Min();
var max = numbers.Max();
var count = numbers.Count();

// Group
var users = new List { ... };
var byAge = users.GroupBy(u => u.Age);
foreach (var group in byAge)
{
    Console.WriteLine($"Age {group.Key}: {group.Count()} users");
}

// Distinct
var unique = numbers.Distinct().ToList();

// Skip/Take (paging)
var page2 = numbers.Skip(3).Take(3).ToList(); // [4, 5, 6]

// LINQ Tips
- Use ToList() to execute query
- LINQ is lazy (executed when iterated)
- Order matters for performance
- Use FirstOrDefault() for safety
- Use Any() instead of Count() > 0

💡 LINQ Tips

  • Use ToList() to execute query
  • LINQ is lazy (executed when iterated)
  • Order matters for performance
  • Use FirstOrDefault() for safety
  • Use Any() instead of Count() > 0

“LINQ queries collections elegantly. Filter, sort, group — all in one. Essential for C# development.”

— C# Developer

Related posts:

C#: Ref Structs Can Now Implement IDisposable (C# 8)

C#: Ref Structs Can Now Implement IDisposable (C# 8)

C#: Fix a Custom Equals Override That Silently Breaks Dictionary and HashSet Lookups

C#: Fix a Custom Equals Override That Silently Breaks Dictionary and HashSet Lookups

C#: Use Tuples for Multiple Return Values

C#: Use Tuples for Multiple Return Values

Views: 13

Post navigation

C#: Use Async/Await for Asynchronous Programming
Visual Studio: Use Code Cleanup for Consistent Formatting

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