Common.QueryKit 1.0.4

Common.QueryKit

Lightweight • EF Core--safe • Dynamic query composition library
Build powerful, fully SQL-translatable filters, sorts & paging on IQueryable<T>

Perfect for enterprise ASP.NET Core apps:
ERP systems • School Management • Admin Panels • Reporting APIs

✨ Highlights

• 100% SQL-translatable (no client evaluation)
• Nested properties support ("Class.GradeLevel", "Address.City.Country")
• Strongly-typed FilterOperator enum
• Multi-column sorting with direction control
• Range filtering (Between), In, null checks
• Property whitelisting for security
• Clean & simple pagination
• Explicit Count-safe API
• Minimal footprint, predictable performance

📦 Installation

dotnet add package Common.QueryKit

🚀 Quick Start

var request = new QueryRequest
{
    Filters =
    [
        new() { Property = "FullName", Operator = FilterOperator.Contains, Value = "john" },
        new() { Property = "BirthDate", Operator = FilterOperator.Between, From = new DateTime(2000,1,1), To = new DateTime(2010,12,31) },
        new() { Property = "Status", Operator = FilterOperator.In, Value = new[] { "Active", "Pending" } }
    ],

    Sorts =
    [
        new() { Property = "Class.Name" },
        new() { Property = "CreatedAt", Descending = true }
    ],

    Page = 1,
    PageSize = 25
};

Fetch paged data

var students = await dbContext.Students
    .Apply(request)
    .ToListAsync();

Fetch total count (safe -- no paging)

var totalCount = await dbContext.Students
    .ApplyForCount(request)
    .CountAsync();

🔧 Supported Operators

Operator Description

Equals == NotEquals != Contains string contains StartsWith starts with EndsWith ends with GreaterThan > GreaterThanOrEqual ≥ LessThan < LessThanOrEqual ≤ Between value between From ↔ To In value in collection NotIn value not in collection IsNull is null IsNotNull is not null

🛡️ Property Whitelisting (Strongly Recommended)

var allowed = new PropertyWhitelist(
    "Id", "FullName", "Email", "BirthDate",
    "Class.Name", "Class.GradeLevel", "CreatedAt"
);

var students = dbContext.Students
    .Apply(request, allowed)
    .ToList();

📋 Requirements

• .NET 8.0+
• Entity Framework Core 8.0+

❤️ License

MIT License

Created with ♥ by Muammar Siddiqui • Innovador Solutions

Happy querying! 🚀