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 96,227 11/10/2017
3.0.0 1,959 11/1/2017
2.11.0-beta2 244 9/18/2017
2.11.0-beta1 104 9/18/2017
2.10.0 61,308 7/25/2017
2.9.1 591 7/24/2017
2.9.0 1,807 7/17/2017
2.8.1 11,343 6/26/2017
2.8.0 579 6/25/2017
2.7.0 33,081 5/10/2017
2.6.0 55,751 1/5/2017
2.5.0 13,323 12/2/2016
2.4.0 15,732 10/3/2016
2.3.0 33,902 8/3/2016
2.2.0 4,534 7/20/2016
2.1.0 7,081 7/7/2016
2.0.0 468 7/6/2016
1.4.11 91,911 6/12/2016
1.4.10.3 633 6/12/2016
1.4.10.2 31,096 4/24/2016
1.4.10.1 422 4/22/2016
1.4.10 428 4/21/2016
1.4.9 1,603 4/8/2016
1.4.8 1,337 3/23/2016
1.4.7 19,162 2/11/2016
1.4.6 23,019 12/17/2015
1.4.5 4,260 12/1/2015
1.4.4 2,014 11/17/2015
1.4.3 5,129 10/26/2015
1.4.2 2,401 10/16/2015
1.4.1 19,746 8/19/2015
1.4.0 7,684 6/14/2015
1.3.16 10,341 6/1/2015
1.3.15 3,967 5/16/2015
1.3.14 719 5/10/2015
1.3.13 5,106 4/1/2015
1.3.12 266 3/28/2015
1.3.11 300 3/24/2015
1.3.10 304 3/12/2015
1.3.9 3,508 3/5/2015
1.3.8 309 2/18/2015
1.3.7 724 2/17/2015
Show less