EntityFramework.DynamicFilters 1.4.10.1

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.1
dotnet add package EntityFramework.DynamicFilters --version 1.4.10.1
<PackageReference Include="EntityFramework.DynamicFilters" Version="1.4.10.1" />
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.1
The NuGet Team does not provide support for this client. Please contact its maintainers for support.
#r "nuget: EntityFramework.DynamicFilters, 1.4.10.1"
#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.1

// Install EntityFramework.DynamicFilters as a Cake Tool
#tool nuget:?package=EntityFramework.DynamicFilters&version=1.4.10.1
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.
1.4.10.1: Fixed to remove multiple occurrences of filter disabled params (can appear multiple times in complex queries)

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