.net core 2.0 global filter for IsDeleted column

429 Views Asked by At

I want to add global filter for deleted row by entity framework. And i achieve this by this code in DbContext class.

protected override void OnModelCreating(ModelBuilder modelBuilder)
{
    modelBuilder.Entity<Role>().HasQueryFilter(p => !p.IsDeleted);
    modelBuilder.Entity<User>().HasQueryFilter(p => !p.IsDeleted);
    modelBuilder.Entity<Foo>().HasQueryFilter(p => !p.IsDeleted);
    modelBuilder.Entity<Bar>().HasQueryFilter(p => !p.IsDeleted);
    .
    .
    .
}

But for every table, i am adding new row to OnModelCreating method. How can i do this with one row for every table like this?

protected override void OnModelCreating(ModelBuilder modelBuilder)
{
    modelBuilder.Entity<T>().HasQueryFilter(p => !p.IsDeleted);
}
0

There are 0 best solutions below