Install-Package FluentSortingDotNet| Version | Description | API Changes |
|---|---|---|
| Major | Big breaking changes, new features, and improvements | Yes |
| Minor | New features, improvements, minor breaking changes (e.g. renaming, removing, or adding parameters) | Yes |
| Patch | Bug fixes, performance improvements, and minor changes | No |
- Parse sort parameters from a string in the format
name,-age- A custom parser can be added by extending the
SortParameterParserclass or implementing theISortParameterParserinterface.
- A custom parser can be added by extending the
- Sort an
IQueryable<T>based on the parsed parameters - Handle invalid sort parameters
public record Person(string Name, int Age);using FluentSortingDotNet;
public sealed class PersonSorter : Sorter<Person>
{
protected override void Configure(SortBuilder<Person> builder)
{
// When no parameters are provided, sort by name descending
builder.ForParameter(p => p.Name).IsDefault(direction: SortDirection.Descending);
builder.ForParameter(p => p.DateOfBirth).WithName("age").ReverseDirection();
// Ignore case when sorting by name
builder.IgnoreParameterCase();
// Ignore invalid parameters instead of throwing an exception when not validated with PersonSorter.Validate(string)
builder.IgnoreInvalidParameters();
}
}using FluentSortingDotNet;
PersonSorter sorter = new();
SortContext sortContext = sorter.Validate("name,-age");
if (!sortContext.IsValid)
{
Console.WriteLine($"Invalid sort parameters: {string.Join(", ", sortContext.InvalidParameters)}");
return;
}
IQueryable<Person> peopleQuery = ...;
IQueryable<Person> sortedQuery = sorter.Sort(peopleQuery, sortContext);services.AddSingleton<ISorter<Person>, PersonSorter>();Extensibility will be improved hand in hand with the stability of the library. The API is currently subject to breaking changes. If you have any suggestions, please open an issue.
To create a custom sort parameter parser, extend the SortParameterParser class or implement the ISortParameterParser interface.
using FluentSortingDotNet;
using FluentSortingDotNet.Parser;
// Parse a query in the format `name.asc,age.desc`
public sealed class CustomSortParameterParser : SortParameterParser
{
protected override int IndexOfSeparator(ReadOnlySpan<char> query)
=> query.IndexOf(',');
public override bool TryParseParameter(ReadOnlySpan<char> parameter, out SortParameter sortParameter)
{
SortDirection direction = SortDirection.Ascending;
if (parameter.IsEmpty)
{
sortParameter = SortParameter.Empty;
return false;
}
var directionSeperatorIndex = parameter.IndexOf('.');
if (directionSeperatorIndex == -1)
{
sortParameter = SortParameter.Empty;
return false;
}
var parameterName = parameter.Slice(0, directionSeperatorIndex).ToString();
var directionName = parameter.Slice(directionSeperatorIndex + 1).ToString();
switch (directionName)
{
case "asc":
direction = SortDirection.Ascending;
break;
case "desc":
direction = SortDirection.Descending;
break;
default:
sortParameter = SortParameter.Empty;
return false;
}
sortParameter = new SortParameter(parameterName, direction);
return true;
}
}using FluentSortingDotNet;
public sealed class PersonSorter() : Sorter<Person>(new CustomSortParameterParser())
{
// Code omitted for brevity
}To create a custom query builder, implement the ISortQueryBuilder interface along with a ISortQueryBuilderFactory that creates the query builder. This will rarely be needed since the default query builder is very efficient. By default the DefaultSortQueryBuilderFactory<T> is used to create dynamic queries and the ExpressionSortQueryBuilder<T> is used to create precompiled queries for the default sort parameters.
The library is designed to be fast and memory efficient. The area that is yet to be optimized is the reflection used to call all the OrderBy methods.
The query building is very fast.
It has a slightly worse performance (when using a sort query string) than calling the OrderBy, OrderByDescending, ThenBy, and ThenByDescending methods directly.
The performance is slightly better when sorting on the default sort parameters since the query is precompiled.
Both of the benchmarked query builders allocate a bit less memory since the expressions are reused.
| Method | Mean | Error | StdDev | Ratio | RatioSD | Allocated | Alloc Ratio |
|---|---|---|---|---|---|---|---|
| Default | 465.9 μs | 6.89 μs | 6.45 μs | 0.98 | 0.02 | 16.78 KB | 0.94 |
| Compiled | 470.9 μs | 6.06 μs | 5.67 μs | 0.99 | 0.02 | 16.67 KB | 0.94 |
| Linq | 474.9 μs | 6.39 μs | 5.98 μs | 1.00 | 0.02 | 17.82 KB | 1.00 |
The parsing has no real-world impact on performance.
| Method | Query | Mean | Error | StdDev | Allocated |
|---|---|---|---|---|---|
| ParseFirst | -a,b | 16.58 ns | 0.209 ns | 0.196 ns | 24 B |
| ParseFirst | a | 16.94 ns | 0.074 ns | 0.061 ns | 24 B |
| ParseFirst | a,b,-c,d,-e,-f,g | 16.63 ns | 0.153 ns | 0.143 ns | 24 B |