EntityFramework.DynamicFilters 2.5.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.5.0
dotnet add package EntityFramework.DynamicFilters --version 2.5.0
paket add EntityFramework.DynamicFilters --version 2.5.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.

Version History

Version Downloads Last updated
3.0.1 94,374 11/10/2017
3.0.0 1,952 11/1/2017
2.11.0-beta2 243 9/18/2017
2.11.0-beta1 103 9/18/2017
2.10.0 60,906 7/25/2017
2.9.1 590 7/24/2017
2.9.0 1,806 7/17/2017
2.8.1 11,335 6/26/2017
2.8.0 578 6/25/2017
2.7.0 32,874 5/10/2017
2.6.0 55,455 1/5/2017
2.5.0 13,274 12/2/2016
2.4.0 15,708 10/3/2016
2.3.0 33,809 8/3/2016
2.2.0 4,519 7/20/2016
2.1.0 6,948 7/7/2016
2.0.0 467 7/6/2016
1.4.11 91,737 6/12/2016
1.4.10.3 632 6/12/2016
1.4.10.2 31,014 4/24/2016
1.4.10.1 421 4/22/2016
1.4.10 427 4/21/2016
1.4.9 1,597 4/8/2016
1.4.8 1,331 3/23/2016
1.4.7 19,147 2/11/2016
1.4.6 22,995 12/17/2015
1.4.5 4,251 12/1/2015
1.4.4 2,011 11/17/2015
1.4.3 5,126 10/26/2015
1.4.2 2,398 10/16/2015
1.4.1 19,660 8/19/2015
1.4.0 7,671 6/14/2015
1.3.16 10,338 6/1/2015
1.3.15 3,965 5/16/2015
1.3.14 718 5/10/2015
1.3.13 5,105 4/1/2015
1.3.12 265 3/28/2015
1.3.11 299 3/24/2015
1.3.10 303 3/12/2015
1.3.9 3,453 3/5/2015
1.3.8 308 2/18/2015
1.3.7 723 2/17/2015
Show less