EntityFramework.DynamicFilters 2.7.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.7.0
dotnet add package EntityFramework.DynamicFilters --version 2.7.0
paket add EntityFramework.DynamicFilters --version 2.7.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.
2.3: Fixed issue with entry.Load() on child collections
2.4: Fixed null exception error on a filter of child property that is also TPT
2.5: Fixed filtered child property of same type as parent entity builds backwards join condition.  Added support for ?? operator.
2.6: Fixed issue with filter not applied when defined on derived class involved in TPH.  Fixed filter not applied to navigation property when nav prop is a TPT entity.  Fixed issue with filter on nullable property specified as null via parameter (not delegate).
2.7: Fixed exception when accessing class in deep inheritance graph

Version History

Version Downloads Last updated
3.0.1 76,646 11/10/2017
3.0.0 1,807 11/1/2017
2.11.0-beta2 227 9/18/2017
2.11.0-beta1 85 9/18/2017
2.10.0 56,071 7/25/2017
2.9.1 563 7/24/2017
2.9.0 1,760 7/17/2017
2.8.1 11,013 6/26/2017
2.8.0 541 6/25/2017
2.7.0 30,620 5/10/2017
2.6.0 52,157 1/5/2017
2.5.0 12,676 12/2/2016
2.4.0 15,333 10/3/2016
2.3.0 33,024 8/3/2016
2.2.0 4,413 7/20/2016
2.1.0 6,231 7/7/2016
2.0.0 443 7/6/2016
1.4.11 89,549 6/12/2016
1.4.10.3 612 6/12/2016
1.4.10.2 30,421 4/24/2016
1.4.10.1 402 4/22/2016
1.4.10 404 4/21/2016
1.4.9 1,553 4/8/2016
1.4.8 1,306 3/23/2016
1.4.7 19,020 2/11/2016
1.4.6 22,828 12/17/2015
1.4.5 4,165 12/1/2015
1.4.4 1,987 11/17/2015
1.4.3 4,922 10/26/2015
1.4.2 2,366 10/16/2015
1.4.1 18,334 8/19/2015
1.4.0 7,597 6/14/2015
1.3.16 10,245 6/1/2015
1.3.15 3,928 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,719 3/5/2015
1.3.8 288 2/18/2015
1.3.7 700 2/17/2015
Show less