c# - Entity Framework 核心过滤器 DbSet

Question

Entity Framework Core 中是否可以自动过滤 DbSet<TEntity>的 DbContext ？我正在寻找实现 something like that仅适用于 EntityFrameworkCore。我想自动过滤 IQueryable<TEntity>在通过 DbSet<TEntity> 访问它之前.

Answer 1

您可以查看下面的链接。

https://learn.microsoft.com/en-us/ef/core/what-is-new/ef-core-2.0#model-level-query-filters

例子

public class BloggingContext : DbContext
{
    public DbSet<Blog> Blogs { get; set; }
    public DbSet<Post> Posts { get; set; }

    public int TenantId { get; set; }

    protected override void OnModelCreating(ModelBuilder modelBuilder)
    {
        modelBuilder.Entity<Post>().HasQueryFilter(
            p => !p.IsDeleted
            && p.TenantId == this.TenantId );
    }
}