Gridify.EntityFramework 1.0.0

Gridify

Easy and optimize way to apply paging, filtering and sorting using string based conditions and filed names.

The best use case of this library is Aspnet APIs when you need to get some string base filtering conditions or sort data by filed name or order data by propery name and use that information to retrieve requested data from a repository or database. at the end send back pageable sorted and filtered data to the user.

Available Extentions

Supported Filtering Operators

we can easily create complex queries using Parenthesis() with AND (,) + OR (|) operators.

Basic Usage example

// usually, we don't need to create this object manually
// for example, we get this object as a parameter from our API Controller
var filter = new QueryObject() 
{
    Filter = "FirstName == John",
    IsSortAsc = false,
    Page = 1,
    PageSize = 20,
    SortBy = "LastName"
};

Paging<Person> pData =
         myDbContext.Persons  // we can use Any list or repository or EntityFramework context
          .Gridify(filter); // Filter,Sort & Apply Paging 
          

// pData.TotalItems => Count persons with 'John', First name
// pData.Items      => First 20 Persons with 'John', First Name

Collaboration

Any collaboration to improve documentation and library is appreciated feel free to send pullrequest. ❤️