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#: Advanced LINQ Query Patterns for Complex Data

- 15.08.26 - ErcanOPAK

🔍 Advanced LINQ = Complex Data

Simple LINQ isn’t always enough. Advanced LINQ patterns handle complex data transformations.

📝 Advanced LINQ Patterns

// Dynamic Query
public IQueryable ApplyFilters(IQueryable query, Dictionary filters)
{
    foreach (var filter in filters)
    {
        var property = typeof(T).GetProperty(filter.Key);
        if (property != null)
        {
            query = query.Where(x => property.GetValue(x).Equals(filter.Value));
        }
    }
    return query;
}

// Expression Tree
public static Expression> BuildPredicate(
    string propertyName, object value)
{
    var parameter = Expression.Parameter(typeof(T));
    var property = Expression.Property(parameter, propertyName);
    var constant = Expression.Constant(value);
    var equal = Expression.Equal(property, constant);
    return Expression.Lambda>(equal, parameter);
}

// Self-Join for Hierarchy
var hierarchy = employees
    .Join(employees,
        e => e.ManagerId,
        m => m.Id,
        (e, m) => new 
        { 
            Employee = e.Name, 
            Manager = m.Name,
            Level = 1
        });

// Cross Join (Cartesian Product)
var combinations = from p in products
                   from c in colors
                   select new { Product = p.Name, Color = c };

// Custom Aggregation
var stats = data
    .GroupBy(x => x.Category)
    .Select(g => new
    {
        Category = g.Key,
        Count = g.Count(),
        Sum = g.Sum(x => x.Value),
        Avg = g.Average(x => x.Value),
        Median = g
            .OrderBy(x => x.Value)
            .Skip(g.Count() / 2)
            .FirstOrDefault()?.Value
    });

🎯 Performance Optimization

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

// Batch Operations
var batches = data
    .Select((item, index) => new { item, index })
    .GroupBy(x => x.index / 100)
    .Select(g => g.Select(x => x.item));

// Parallel LINQ
var results = data
    .AsParallel()
    .WithDegreeOfParallelism(Environment.ProcessorCount)
    .Where(x => IsValid(x))
    .Select(x => ProcessItem(x))
    .ToList();

// Caching Results
private static readonly ConcurrentDictionary _cache = new();

public T GetOrAdd(string key, Func factory)
{
    return (T)_cache.GetOrAdd(key, _ => factory());
}

// Efficient Updates
var itemsToUpdate = data
    .Where(x => x.IsActive)
    .Select(x => new 
    { 
        x.Id, 
        UpdatedValue = x.Value * 1.1 
    })
    .ToList();

💡 Advanced LINQ Tips

  • Use compiled queries for EF Core
  • Implement expression trees for dynamic queries
  • Use parallel LINQ for CPU-bound operations
  • Cache frequently used queries
  • Use batch operations for large datasets

Advanced LINQ patterns unlock the full power of data querying. They make complex transformations elegant and efficient.

— Data Engineer

Related posts:

C#: Use Nullable Reference Types for Null Safety

C#: Use Nullable Reference Types for Null Safety

C#: Fix a Manually-Driven IEnumerator Whose finally Block Never Runs Because Nobody Called Dispose

C#: Fix a Manually-Driven IEnumerator Whose finally Block Never Runs Because Nobody Called Dispose

C#: Simulating Discriminated Unions with Modern Pattern Matching

C#: Simulating Discriminated Unions with Modern Pattern Matching

Views: 7

Post navigation

C#: Implementing Retry Patterns with Async/Await
Visual Studio: Task List and TODO Comments for Better Workflow

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 (576)
  • 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