Ezocel.RowsQuerier 2.1.0

Ezocel RowsQuerier

A powerful server-side data grid engine for .NET. Translates grid requests (filtering, sorting, grouping, pagination) into LINQ expressions executed directly against your IQueryable data source.

Features

• Server-side filtering with text, numeric, date, and boolean operators
• Multi-column sorting with chained OrderBy/ThenBy
• Row grouping with hierarchical support and aggregations (Sum, Avg, Min, Max, Count)
• Server-side pagination with infinite scrolling support
• Property projection to optimize query bandwidth
• Authorization handlers for granular access control
• Static filters for tenant isolation and data scoping
• Output transformers to reshape or enrich response data
• Schema generation exposing column metadata to frontends
• Zero third-party dependencies in the core library

Installation

dotnet add package Ezocel.RowsQuerier

For ASP.NET Core integration (controllers, endpoints, AG-Grid scheme):

dotnet add package Ezocel.RowsQuerier.AspNetCore

Quick Start

1. Define a connector

A connector is a class decorated with [RowsQuerierConnector] that maps to your data source. Each connector must specify a queryable provider and should have at least one sorted property:

using Ezocel.RowsQuerier;

[RowsQuerierConnector("products", typeof(ProductQueryableProvider),
    PropertyDiscoveryStrategy = PropertyDiscoveryStrategy.TakeAll)]
public class Product
{
    [RowsQuerierProperty(Options = PropertyOptions.SortedDesc)]
    public int Id { get; set; }
    public string Name { get; set; }
    public decimal Price { get; set; }
    public string Category { get; set; }
    public DateTime CreatedDate { get; set; }
    public bool IsAvailable { get; set; }
}

The queryable provider implements IQueryableProvider<T> and returns your data source:

public class ProductQueryableProvider(AppDbContext db) : IQueryableProvider<Product>
{
    public IQueryable<Product> GetQueryable() => db.Products.AsNoTracking();
}

2. Register RowsQuerier

builder.Services.AddRowsQuerier()
    .SetLicenseKey("RQ-bKiORbm-aFfFzzM-uQuwcJ0")
    .AddConnectors(typeof(Program).Assembly);

Or register a connector inline with a lambda:

builder.Services.AddRowsQuerier()
    .SetLicenseKey("RQ-bKiORbm-aFfFzzM-uQuwcJ0");
    .AddConnector<Product>("products",
        provideQueryable: sp => sp.GetRequiredService<AppDbContext>().Products,
        optionsBuilder: options => options.SetPropertyDiscoveryStrategy(PropertyDiscoveryStrategy.TakeAll));

3. Query your data

var querier = serviceProvider.GetRequiredService<RowsQuerier>();
var response = await querier.GetRowsAsync(new GetRowsRequest
{
    ConnectorName = "products",
    StartRow = 0,
    RowsCount = 50
});

Documentation

Full documentation, examples, and guides are available at rowsquerier.com/documentation.

License

This package is provided under the Ezocel RowsQuerier Software License Agreement. Free for development and evaluation. A purchased license key is required for production use. Visit rowsquerier.com for details.