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
  • Privacy Policy
C#

C#: Expression Trees ile Runtime Query Oluşturma

- 18.08.26 - ErcanOPAK

🧠 Expression Trees = Dynamic Queries

Statik sorgular yeterli değil. Expression Trees ile runtime’da dinamik LINQ sorguları oluşturun.

🎯 Expression Tree Örnekleri

// 1. Dinamik WHERE
public static Expression> BuildFilter(
    string propertyName, string operation, object value)
{
    var parameter = Expression.Parameter(typeof(T), "x");
    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);
}

// 2. Dinamik OrderBy
public static IQueryable OrderByDynamic(
    this IQueryable query, string propertyName, bool ascending = true)
{
    var parameter = Expression.Parameter(typeof(T), "x");
    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);
    
    return (IQueryable)method.Invoke(null, new object[] { query, lambda });
}

// 3. Predicate Builder
public static class PredicateBuilder
{
    public static Expression> True() { return f => true; }
    
    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);
    }
}

✅ Expression Tree Kullanım Alanları

  • ✓ Dinamik filtreleme
  • ✓ Runtime sorgu oluşturma
  • ✓ Özel LINQ provider’lar
  • ✓ ORM sorgu optimizasyonu
  • ✓ Rule engine implementasyonu

Expression Trees, C#’ın en güçlü özelliklerinden biridir. Runtime’da dinamik sorgular oluşturarak esnek çözümler üretebilirsiniz.

— .NET Uzmanı

Related posts:

Step-by-Step: Building a Modern Console App with C# 13

Time Zones — DateTime.Now Is a Data Corruption Bug

Task.Run Inside ASP.NET Core Hurts Scalability

Post Views: 2

Post navigation

SQL: PostgreSQL Window Functions ile Karmaşık Veri Analizi
JavaScript: Generators ile Stream Processing

Leave a Reply Cancel reply

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

October 2026
M T W T F S S
 1234
567891011
12131415161718
19202122232425
262728293031  
« Sep    

Most Viewed Posts

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

Recent Posts

  • CSS: Fix a prefers-color-scheme Media Query That Gets Silently Overridden by a Browser Extension’s Forced Dark Mode
  • Git: Fix a Merge Commit That Silently Drops a File Because Both Branches Deleted It Differently
  • HTML5: Fix a Native Lazy-Loading Image That Never Loads Because It Sits Inside a Hidden Tab Until the User Clicks It
  • The AI Prompt That Traces a Null Reference Exception Back to the Exact Line That First Produced the Null
  • The AI Prompt That Turns a Gym Membership Contract’s Fine Print Into a Plain-English List of Cancellation Steps
  • Photoshop: Fix a Color Profile Mismatch That Makes Printed Output Look Nothing Like What You Saw On Screen
  • WordPress: Fix Search Results That Return Pages From a Theme You Deactivated Months Ago
  • Visual Studio: Fix a Test Project That Builds Fine Alone but Fails to Discover Any Tests After a NuGet Restore
  • ASP.NET Core: Fix a File Upload That Times Out on Slow Connections Only Because Kestrel’s Minimum Data Rate Feature Kicked In
  • JavaScript: Fix an Array Destructuring Default Value That Silently Never Applies Because null Was Passed Instead of Undefined

Most Viewed Posts

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

Recent Posts

  • CSS: Fix a prefers-color-scheme Media Query That Gets Silently Overridden by a Browser Extension’s Forced Dark Mode
  • Git: Fix a Merge Commit That Silently Drops a File Because Both Branches Deleted It Differently
  • HTML5: Fix a Native Lazy-Loading Image That Never Loads Because It Sits Inside a Hidden Tab Until the User Clicks It
  • The AI Prompt That Traces a Null Reference Exception Back to the Exact Line That First Produced the Null
  • The AI Prompt That Turns a Gym Membership Contract’s Fine Print Into a Plain-English List of Cancellation Steps

Social

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