Completely handle PrimeNG table load lazy in ASP.NET use PrimeNG.TableFilter

Release note - version 2.0.0

Big Refactor code structure for easy maintenance
Fully support .Net Core 3.1 and .Net 5
Change CI build from .Net Core 2.2 to 3.1
Support new PrimeNG multi condition (#14)
Official support IEnumerableobject type
Fixbug and improvement

My Development team is develop multiple master data preview in table component use the PrimeNG Table. The PrimeNG Table is smart multi-function table component. The component can sorting, searching, multiple condition sorting and UI customization.

https://primefaces.org/primeng/showcase/#/table

PrimeNG table component has a feature "lazy-load", Lazy-load is feature for handle large dataset, This feature can send query payload for paging, sorting, filtering to backend for query you dataset.

Backward to backend, My Development team use C# ASP.NET Core in backend system. We're manual handle payload query in PrimeNG table lazy-load mode in every master data page and transaction page.

A pain point is we doing routine implement manual handle PrimeNG table lazy-load payload every module in application

I'm release library for shorten way for handle PrimeNG table lazy-load for save the time for implementation in every module for my team.

Kusumoto/PrimeNG.TableFilter

Helper for use the PrimeNG table load lazy filter in backend use LINQ to Entity - Kusumoto/PrimeNG.TableFilter

GitHubKusumoto

PrimeNG.TableFilter is helper library for handle table lazy-load in PrimeNG Table with "One Extension Methods"

PrimeNG.TableFilter use the C# reflection for access the properties in your entity or model and generate LINQ's command for manage iterator or generate SQL command for filter from payload conditions.

In case generate SQL command, PrimeNG.TableFilter has wrapper the Entity Framework for use the LINQ2Entity feature for generate general SQL command. Is means PrimeNG.TableFilter has support all RDMS of Entity Framework support.

Core Feature

Example code snippet

Table sorting

Table multiple condition filter

Mix multiple condition filter and general filter

Auto Pagination

Limitation

PrimeNG.TableFilter is wrapper of Entity Framework, A SQL query generated by Entity Framework, The query performance depend on LINQ2Entity engine.
DateTime filtering condition not support (issue #9)

Feature request: implement comparism for Nullable DateTimes and extended methods · Issue #9 · Kusumoto/PrimeNG.TableFilter

Hello again, thank you for this plugin and the great support for the last feature! It would be great to have some new features for filtering ranges of dates in the upcoming version: support compari...

GitHubKusumoto

You can find the example ASP.NET Core project.

Kusumoto/PrimeNG.TableFilter.Example

Contribute to Kusumoto/PrimeNG.TableFilter.Example development by creating an account on GitHub.

GitHubKusumoto