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#: Dynamic LINQ Queries with Expression Trees

- 16.08.26 - ErcanOPAK

🔧 Dynamic LINQ = Flexible Queries

Static queries aren’t always enough. Dynamic LINQ with expression trees builds queries at runtime.

📝 Dynamic Query Builder

public class DynamicQueryBuilder
{
    private IQueryable _query;

    public DynamicQueryBuilder(IQueryable query)
    {
        _query = query;
    }

    public DynamicQueryBuilder Filter(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);
        var lambda = Expression.Lambda>(equal, parameter);
        
        _query = _query.Where(lambda);
        return this;
    }

    public DynamicQueryBuilder OrderBy(string propertyName, bool ascending = true)
    {
        var parameter = Expression.Parameter(typeof(T));
        var property = Expression.Property(parameter, propertyName);
        var lambda = Expression.Lambda(property, parameter);
        
        var methodName = ascending ? "OrderBy" : "OrderByDescending";
        var method = typeof(Queryable).GetMethods()
            .First(m => m.Name == methodName && m.GetParameters().Length == 2)
            .MakeGenericMethod(typeof(T), property.Type);
        
        _query = (IQueryable)method.Invoke(null, new object[] { _query, lambda });
        return this;
    }

    public DynamicQueryBuilder Skip(int count)
    {
        _query = _query.Skip(count);
        return this;
    }

    public DynamicQueryBuilder Take(int count)
    {
        _query = _query.Take(count);
        return this;
    }

    public IQueryable Build() => _query;
}

🎯 Advanced Expression Trees

// Build Expression for Complex Conditions
public static Expression> BuildPredicate(
    string propertyName,
    string operation,
    object value)
{
    var parameter = Expression.Parameter(typeof(T));
    var property = Expression.Property(parameter, propertyName);
    var constant = Expression.Constant(value);
    
    Expression condition = operation switch
    {
        "Equals" => Expression.Equal(property, constant),
        "GreaterThan" => Expression.GreaterThan(property, constant),
        "LessThan" => Expression.LessThan(property, constant),
        "Contains" => Expression.Call(property, 
            typeof(string).GetMethod("Contains", new[] { typeof(string) }), constant),
        _ => throw new NotSupportedException()
    };
    
    return Expression.Lambda>(condition, parameter);
}

// Predicate Builder
public static class PredicateBuilder
{
    public static Expression> True() { return f => true; }
    public static Expression> False() { return f => false; }

    public static Expression> Or(
        this Expression> expr1,
        Expression> expr2)
    {
        var invokedExpr = Expression.Invoke(expr2, expr1.Parameters);
        return Expression.Lambda>(
            Expression.OrElse(expr1.Body, invokedExpr),
            expr1.Parameters);
    }

    public static Expression> And(
        this Expression> expr1,
        Expression> expr2)
    {
        var invokedExpr = Expression.Invoke(expr2, expr1.Parameters);
        return Expression.Lambda>(
            Expression.AndAlso(expr1.Body, invokedExpr),
            expr1.Parameters);
    }
}

// Usage
var predicate = PredicateBuilder.True();
if (!string.IsNullOrEmpty(nameFilter))
{
    predicate = predicate.And(u => u.Name.Contains(nameFilter));
}
if (minAge.HasValue)
{
    predicate = predicate.And(u => u.Age >= minAge.Value);
}
var results = context.Users.Where(predicate).ToList();

💡 Dynamic LINQ Tips

  • Use expression trees for dynamic queries
  • Build predicates conditionally
  • Chain operations for complex queries
  • Handle null values carefully
  • Test with different data types

Dynamic LINQ with expression trees enables flexible, runtime-constructed queries. It’s powerful and performant.

— Senior Developer

Related posts:

C#: Better Exception Messages with [CallerArgumentExpression]

C#: Better Exception Messages with [CallerArgumentExpression]

C# Foreach vs For Performance Difference

C# Foreach vs For Performance Difference

C# “Enum Flags” — The Powerful Feature 90% Underuse

C# “Enum Flags” — The Powerful Feature 90% Underuse

Views: 11

Post navigation

C#: Implementing Timeouts with Cancellation Tokens
Visual Studio: NuGet Package Management for Dependencies

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