EntityFramework.DynamicFilters 1.4.10

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 1.4.10
dotnet add package EntityFramework.DynamicFilters --version 1.4.10
<PackageReference Include="EntityFramework.DynamicFilters" Version="1.4.10" />
For projects that support PackageReference, copy this XML node into the project file to reference the package.
paket add EntityFramework.DynamicFilters --version 1.4.10
The NuGet Team does not provide support for this client. Please contact its maintainers for support.
#r "nuget: EntityFramework.DynamicFilters, 1.4.10"
#r directive can be used in F# Interactive, C# scripting and .NET Interactive. 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=1.4.10

// Install EntityFramework.DynamicFilters as a Cake Tool
#tool nuget:?package=EntityFramework.DynamicFilters&version=1.4.10
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.4: Added support for bitwise operators And/&, Or/|, and Xor/^
1.4.5: Fixed handling of "!Contains(x)"
1.4.6: Rebuild to fix UNC paths and slow startup when trying to load debug symbols
1.4.7: Added GetFilterParameterValue method for unnamed parameter
1.4.8: Fixed Contains() to support IEnumerable collections
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.

NuGet packages (23)

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

Package Downloads
Abp.EntityFramework
Abp.EntityFramework
Stove.EntityFramework
EntityFramework integration for Stove.
Witcare.Data
Witcare Data dll
Skymate.EntityFramework
Skymate Framework
Vstack.Services
Vstack.Services

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
Jimmey-Jiang/ABP-ASP.NET-Boilerplate-Project-CMS
ABP module-zero +AdminLTE+Bootstrap Table+jQuery+Redis + sql server+quartz+hangfire权限管理系统
aspnetboilerplate/eventcloud
Sample SaaS (Multi Tenant) Event Management Application
stoveproject/Stove
Domain Driven Design oriented application framework, meets CRUD needs

Version History

Version Downloads Last updated
3.2.0 70,938 6/15/2020
3.1.1 149,624 11/3/2019
3.1.0 57,128 7/24/2019
3.0.2-preview6-01 324 7/12/2019
3.0.1 525,861 11/10/2017
3.0.0 8,992 11/1/2017
2.11.0-beta2 713 9/18/2017
2.11.0-beta1 542 9/18/2017
2.10.0 156,499 7/25/2017
2.9.1 1,137 7/24/2017
2.9.0 3,046 7/17/2017
2.8.1 13,612 6/26/2017
2.8.0 1,275 6/25/2017
2.7.0 62,853 5/10/2017
2.6.0 84,949 1/5/2017
2.5.0 18,369 12/2/2016
2.4.0 40,393 10/3/2016
2.3.0 42,372 8/3/2016
2.2.0 7,169 7/20/2016
2.1.0 22,105 7/7/2016
2.0.0 1,050 7/6/2016
1.4.11 176,130 6/12/2016
1.4.10.3 1,237 6/12/2016
1.4.10.2 44,989 4/24/2016
1.4.10.1 937 4/22/2016
1.4.10 989 4/21/2016
1.4.9 2,325 4/8/2016
1.4.8 1,894 3/23/2016
1.4.7 22,448 2/11/2016
1.4.6 29,854 12/17/2015
1.4.5 5,327 12/1/2015
1.4.4 10,639 11/17/2015
1.4.3 7,670 10/26/2015
1.4.2 3,360 10/16/2015
1.4.1 42,624 8/19/2015
1.4.0 9,721 6/14/2015
1.3.16 19,232 6/1/2015
1.3.15 5,662 5/16/2015
1.3.14 1,245 5/10/2015
1.3.13 6,623 4/1/2015
1.3.12 770 3/28/2015
1.3.11 823 3/24/2015
1.3.10 893 3/12/2015
1.3.9 15,524 3/5/2015
1.3.8 827 2/18/2015
1.3.7 1,309 2/17/2015
Show less