Entity Framework Filter

Introduction

Filter allows you to filter data from the DbContext with predefined filters.

Why Filters?

Common Scenarios:

• Default Ordering
• Logical Data Partitioning
• Multi-Tenancy
• Soft Deleted
• Security Access

Google Related Searches

• Entity Framework Dynamic Filter
• Entity Framework Global Filter
• Entity Framework Soft Delete Filter

StackOverflow Related Questions

• Filter all tables on Context Level

// using Z.EntityFramework.Plus; // Don't forget to include this.
var ctx = new EntitiesContext();

ctx.Filter<Post>(q => q.Where(x => !x.IsSoftDeleted));

// SELECT * FROM Post WHERE IsSoftDeleted = false
var list = ctx.Posts.ToList();

Supported Libraries

Unsuported Libraries

Use this library at your risk!