FlexQuery.NET 3.1.1

FlexQuery.NET

Dynamic filtering, sorting, paging, and projection for IQueryable in .NET.

FlexQuery.NET is the core package. It provides the query parsing engine, expression builders, validation pipeline, and all core models.

When to Use This Package

Install this package if you want to parse, validate, and compose dynamic queries independently of any specific data provider. Use this package directly when building custom integrations or when implementing your own query execution pipeline.

Installation

dotnet add package FlexQuery.NET

Quick Start

using FlexQuery.NET;

var parameters = new FlexQueryParameters
{
    Filter = "status:eq:active",
    Sort = "createdAt:desc",
    Page = 1,
    PageSize = 20
};

var options = parameters.ToQueryOptions();

var query = _context.Users.Apply(options);

// Execute using your preferred provider

Features

• Query Parsing — Auto-detects DSL, JSON, and Indexed query formats via QueryOptionsParser.Parse()
• Filtering — 20+ operators (eq, contains, gt, between, in, etc.), nested AND/OR logic
• Sorting — Multi-field sorting with direction and aggregate sort support
• Paging — 1-based page indexing with configurable page size limits
• Security — Declare allowed/blocked fields per-endpoint via BaseQueryOptions
• Validation — Built-in field path, operator, and type validation with ValidateOrThrow<T>()
• Diagnostics — Optional IFlexQueryExecutionListener for observability
• Query Parsing Cache — Thread-safe parser cache for low-latency repeated queries

Supported Query Formats

All formats are auto-detected — no configuration needed.

DSL
GET /api/users?filter=age:gte:18&sort=name:asc

JSON
GET /api/users?filter={"logic":"and","filters":[{"field":"age","operator":"gte","value":18}]}

Indexed
GET /api/users?filter[0].field=age&filter[0].operator=gte&filter[0].value=18

Related Packages

• FlexQuery.NET.EntityFrameworkCore — Async execution for EF Core
• FlexQuery.NET.Dapper — SQL generation for Dapper
• FlexQuery.NET.AspNetCore — ASP.NET Core [FieldAccess] security
• FlexQuery.NET.Diagnostics — Execution diagnostics
• FlexQuery.NET.Adapters.AgGrid — AG Grid SSRM adapter
• FlexQuery.NET.Adapters.Kendo — Kendo UI adapter
• FlexQuery.NET.Parsers.Jql — JQL parser
• FlexQuery.NET.Parsers.MiniOData — OData-compatible parser

Full Documentation:

https://flexquery.vercel.app

• Getting Started
• Query Syntax Reference
• Security & Governance
• API Reference