Common.QueryKit 1.0.2

Here is a ready-to-use, clean README.md file content optimized for GitHub.
You can copy-paste it directly, or save it as README.md.

# 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  
- Minimal footprint, predictable performance

## 📦 Installation

```bash
dotnet add package Common.QueryKit

🚀 Quick Start

var request = new QueryRequest
{
    Filters = new List<FilterRule>
    {
        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,     Values = new[] { "Active", "Pending" } }
    },

    Sorts = new List<SortRule>
    {
        new() { Property = "Class.Name" },
        new() { Property = "CreatedAt", Descending = true }
    },

    Page     = 1,
    PageSize = 25
};

// One-liner
var students = await dbContext.Students
    .Apply(request)
    .ToListAsync();

Or more control:

var query = dbContext.Students
    .ApplyFilters(request.Filters)
    .ApplySorting(request.Sorts)
    .PageBy(request.Page, request.PageSize);

🔧 Supported Operators

🛡️ Property Whitelisting (Strongly Recommended)

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

var result = 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! 🚀