Request Format

DataTableQueryBuilder.DataTables package

Use built-in model binder to automatically bind incoming requests to DataTableRequest model:

using DataTableQueryBuilder.DataTables;
   
public class Startup
{
    public void ConfigureServices(IServiceCollection services)
    {
        //...           
        services.RegisterDataTables();
    }   
}

DataTableQueryBuilder.Generic package

In order to automatically bind incoming requests to DataTableRequest model, your JavaScript datatable should send requests in the following JSON format:

columns: [
    { field: 'fullName', search: 'John' },
    { field: 'companyName', search: 'Goo' },
    { field: 'posts', search: '5', sort: 'asc' },
    { field: 'createDate', search: '05/15/2020', sort: 'desc' }
],
page: 1,
pazeSize: 20,
search: ''

Here:

• fullName, companyName, posts and createDate are fields in a JSON array returned by the server.

• search is a global (multi-column) search value.

• sort value should be either asc or desc. Multi-column sorting is supported.

In case you want to use a different format, you can write a custom ModelBinder that will bind incoming requests to DataTableRequest model that is used by the builder.