FilterSortParsing

A .NET library for parsing and applying OData-like filter and sorting expressions to IQueryable<T> data sources.

Features

• Filter Support - OData-like filter syntax with comparison operators, string functions, and logical operators
• Sorting Support - Multi-field sorting with ascending/descending order
• Case Insensitive - Keywords, operators, and property names
• Nested Properties - Dot notation navigation

Installation

<PackageReference Include="Soukoku.FilterSortParsing" Version="*" />

Quick Start

Filtering

using Soukoku.FilterSortParsing;

var people = dbContext.People.AsQueryable();

// Simple filter
var adults = people.ApplyFilter("Age ge 18");

// Complex filter
var result = people.ApplyFilter(
    "(Age ge 25 and Age le 65) and (Address.State eq 'CA' or Address.State eq 'NY')"
);

// String operations
var johns = people.ApplyFilter("FirstName startswith 'John'");

Sorting

// Single field
var sorted = people.ApplyOrderBy("LastName");

// Multiple fields with directions
var sorted = people.ApplyOrderBy("Age desc, LastName asc, FirstName asc");

Chaining

var result = people
    .ApplyFilter("Age ge 25 and IsActive eq true")
    .ApplyOrderBy("LastName, FirstName")
    .Skip(20)
    .Take(10)
    .ToList();

Filter Operators

Comparison

• eq, ne - Equal, not equal
• gt, ge - Greater than (or equal)
• lt, le - Less than (or equal)

String Functions

• contains, startswith, endswith

Logical

• and, or, not
• ( ) - Grouping and precedence

Sorting Syntax

• Direction: asc, ascending, desc, descending
• Multiple fields: Comma-separated
• Default: Ascending

Documentation

• Filter Documentation - Complete filter syntax and examples
• OrderBy Documentation - Complete sorting syntax

Compatibility

• .NET 8+ - Full support
• .NET Framework 4.6.2+ - Full support with System.Memory backport