EntityFramework.DynamicFilters 2.2.0

There is a newer version of this package available.
See the version list below for details.
dotnet add package EntityFramework.DynamicFilters --version 2.2.0
NuGet\Install-Package EntityFramework.DynamicFilters -Version 2.2.0
This command is intended to be used within the Package Manager Console in Visual Studio, as it uses the NuGet module's version of Install-Package.
<PackageReference Include="EntityFramework.DynamicFilters" Version="2.2.0" />
For projects that support PackageReference, copy this XML node into the project file to reference the package.
paket add EntityFramework.DynamicFilters --version 2.2.0
#r "nuget: EntityFramework.DynamicFilters, 2.2.0"
#r directive can be used in F# Interactive and Polyglot Notebooks. Copy this into the interactive tool or source code of the script to reference the package.
// Install EntityFramework.DynamicFilters as a Cake Addin
#addin nuget:?package=EntityFramework.DynamicFilters&version=2.2.0

// Install EntityFramework.DynamicFilters as a Cake Tool
#tool nuget:?package=EntityFramework.DynamicFilters&version=2.2.0

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.

Product Compatible and additional computed target framework versions.
.NET Framework net40 is compatible.  net403 was computed.  net45 was computed.  net451 was computed.  net452 was computed.  net46 was computed.  net461 was computed.  net462 was computed.  net463 was computed.  net47 was computed.  net471 was computed.  net472 was computed.  net48 was computed.  net481 was computed. 
Compatible target framework(s)
Included target framework(s) (in package)
Learn more about Target Frameworks and .NET Standard.

NuGet packages (26)

Showing the top 5 NuGet packages that depend on EntityFramework.DynamicFilters:

Package Downloads
Abp.EntityFramework The ID prefix of this package has been reserved for one of the owners of this package by NuGet.org.

Abp.EntityFramework

Stove.EntityFramework

EntityFramework integration for Stove.

Witcare.Data

Witcare Data dll

Vstack.Services

Vstack.Services

Skymate.EntityFramework

Skymate Framework

GitHub repositories (4)

Showing the top 4 popular GitHub repositories that depend on EntityFramework.DynamicFilters:

Repository Stars
aspnetboilerplate/aspnetboilerplate
ASP.NET Boilerplate - Web Application Framework
laochiangx/ABP-ASP.NET-Boilerplate-Project-CMS
ABP module-zero +AdminLTE+Bootstrap Table+jQuery+Redis + sql server+quartz+hangfire权限管理系统
stoveproject/Stove
Domain Driven Design oriented application framework, meets CRUD needs
aspnetboilerplate/questions-answers
A sample application using ABP and module-zero
Version Downloads Last updated
3.2.4 424,646 1/26/2022
3.2.3 78,583 12/8/2021
3.2.2 43,256 10/30/2021
3.2.1 16,409 9/17/2021
3.2.0 355,544 6/15/2020
3.1.1 297,303 11/3/2019
3.1.0 150,759 7/24/2019
3.0.2-preview6-01 1,197 7/12/2019
3.0.1 806,707 11/10/2017
3.0.0 16,145 11/1/2017
2.11.0-beta2 1,670 9/18/2017
2.11.0-beta1 1,477 9/18/2017
2.10.0 320,371 7/25/2017
2.9.1 3,191 7/24/2017
2.9.0 5,865 7/17/2017
2.8.1 20,522 6/26/2017
2.8.0 3,117 6/25/2017
2.7.0 82,959 5/10/2017
2.6.0 145,765 1/5/2017
2.5.0 33,709 12/2/2016
2.4.0 95,175 10/3/2016
2.3.0 53,118 8/3/2016
2.2.0 11,085 7/20/2016
2.1.0 27,837 7/7/2016
2.0.0 3,926 7/6/2016
1.4.11 254,301 6/12/2016
1.4.10.3 2,980 6/12/2016
1.4.10.2 52,215 4/24/2016
1.4.10.1 2,190 4/22/2016
1.4.10 2,185 4/21/2016
1.4.9 5,589 4/8/2016
1.4.8 3,246 3/23/2016
1.4.7 26,757 2/11/2016
1.4.6 45,800 12/17/2015
1.4.5 7,010 12/1/2015
1.4.4 18,525 11/17/2015
1.4.3 12,617 10/26/2015
1.4.2 4,594 10/16/2015
1.4.1 61,734 8/19/2015
1.4.0 12,542 6/14/2015
1.3.16 23,487 6/1/2015
1.3.15 8,927 5/16/2015
1.3.14 2,351 5/10/2015
1.3.13 10,917 4/1/2015
1.3.12 2,004 3/28/2015
1.3.11 2,055 3/24/2015
1.3.10 2,064 3/12/2015
1.3.9 17,659 3/5/2015
1.3.8 2,190 2/18/2015
1.3.7 3,795 2/17/2015

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.