EntityFramework.DynamicFilters 2.2.0

Entity Framework Dynamic/Global Filters

Provides global & scoped filters for Entity Framework with dynamic filter parameters that are evaluated at query execution.  Supports use cases such as Multi-Tenancy and Soft Deletes.

There is a newer version of this package available.
See the version list below for details.
Install-Package EntityFramework.DynamicFilters -Version 2.2.0
dotnet add package EntityFramework.DynamicFilters --version 2.2.0
paket add EntityFramework.DynamicFilters --version 2.2.0
The NuGet Team does not provide support for this client. Please contact its maintainers for support.

Release Notes

Full Change Log: https://github.com/jcachat/EntityFramework.DynamicFilters/blob/master/src/CHANGELOG.TXT

1.4.9: Fixed filters not being applied to "ChildCollection.Any()" condition in .Where clause.  Fixed handling of single property bool conditions in filters (i.e. "e.BoolFlag" or "!e.BoolFlag").
1.4.10: Generated SQL now does not include the "OR (@DynamicFilterParam_1 IS NOT NULL)" clause if filter is not disabled - fixes bad index usage in some cases on SQL Server.  Will still be included if filter is disabled.  Also fixed some "contains" issues with MySql.
1.4.10.1: Fixed to remove multiple occurrences of filter disabled params (can appear multiple times in complex queries)
1.4.10.2: Added methods to turn off the enable/disable filter functionality completely so those conditions are not included in sql query at all.
1.4.10.3: Fixed issues removing disabled filter condition on PostgreSQL
1.4.11: Signed the assembly
2.0.0-alpha: Support for filtering on Navigation Properties.  See https://github.com/jcachat/EntityFramework.DynamicFilters/issues/65
2.0: See https://github.com/jcachat/EntityFramework.DynamicFilters#changes-in-version-2 for changes.
2.1: Added support for Any() and All() on child collections
2.2: Fixed SQL generation issue when main query (not filter predicate) contains nullable types.  Added ability to not apply filter to specific types.

Version History

Version Downloads Last updated
3.0.1 75,805 11/10/2017
3.0.0 1,802 11/1/2017
2.11.0-beta2 227 9/18/2017
2.11.0-beta1 85 9/18/2017
2.10.0 55,848 7/25/2017
2.9.1 563 7/24/2017
2.9.0 1,760 7/17/2017
2.8.1 10,905 6/26/2017
2.8.0 541 6/25/2017
2.7.0 30,481 5/10/2017
2.6.0 51,983 1/5/2017
2.5.0 12,646 12/2/2016
2.4.0 15,302 10/3/2016
2.3.0 32,974 8/3/2016
2.2.0 4,413 7/20/2016
2.1.0 6,225 7/7/2016
2.0.0 443 7/6/2016
1.4.11 89,460 6/12/2016
1.4.10.3 612 6/12/2016
1.4.10.2 30,396 4/24/2016
1.4.10.1 402 4/22/2016
1.4.10 404 4/21/2016
1.4.9 1,551 4/8/2016
1.4.8 1,306 3/23/2016
1.4.7 19,016 2/11/2016
1.4.6 22,821 12/17/2015
1.4.5 4,156 12/1/2015
1.4.4 1,987 11/17/2015
1.4.3 4,889 10/26/2015
1.4.2 2,365 10/16/2015
1.4.1 18,275 8/19/2015
1.4.0 7,597 6/14/2015
1.3.16 10,242 6/1/2015
1.3.15 3,927 5/16/2015
1.3.14 695 5/10/2015
1.3.13 5,071 4/1/2015
1.3.12 245 3/28/2015
1.3.11 278 3/24/2015
1.3.10 283 3/12/2015
1.3.9 2,645 3/5/2015
1.3.8 288 2/18/2015
1.3.7 700 2/17/2015
Show less