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);
}