EF Core 2: How to apply HasQueryFilter for all entities

by

In case you have base class or interface defining the IsActive property, you could use the approach from Filter all queries (trying to achieve soft delete).

Otherwise you could iterate entity types, and for each type having bool IsActive property build dynamically filter expression using Expression class methods:

foreach (var entityType in modelBuilder.Model.GetEntityTypes())
{
    var isActiveProperty = entityType.FindProperty("IsActive");
    if (isActiveProperty != null && isActiveProperty.ClrType == typeof(bool))
    {
        var parameter = Expression.Parameter(entityType.ClrType, "p");
        var filter = Expression.Lambda(Expression.Property(parameter, isActiveProperty.PropertyInfo), parameter);
        entityType.QueryFilter = filter;
    }
}

Update (EF Core 3.0): Due to public metadata API breaking change (replacing many properties with Get / Set extension methods), the last line becomes

entityType.SetQueryFilter(filter);

More Related Contents:

  1. EF Core Second level ThenInclude missworks
  2. How to select top N rows for each group in a Entity Framework GroupBy with EF 3.1
  3. Equivalent for .HasOptional in Entity Framework Core 1 (EF7)
  4. ef core 2 apply HasQueryFilter for all entity
  5. Loop/reflect through all properties in all EF Models to set Column Type
  6. EntityFramework Core automatic migrations
  7. Using EF Core ThenInclude() on Junction tables
  8. Changes in IDENTITY column after EF core 3
  9. What goes into DbContextOptions when invoking a new DbContext?
  10. Entity Framework Core 2.0 – Run migrations step by step
  11. Entity Framework – Why explicitly set entity state to modified?
  12. Convert value when mapping
  13. ADO.NET DbContext Generator vs. ADO.NET Poco Entity Generator (ObjectContext)
  14. Entity Framework code first unique column
  15. Entity framework code-first null foreign key
  16. Entity Framework 4.2 exec sp_executesql does not use indexes (parameter sniffing)
  17. Multi-async in Entity Framework 6?
  18. How do you ensure Cascade Delete is enabled on a table relationship in EF Code first?
  19. Value cannot be null. Parameter name: entitySet
  20. SQL Server Express connection string for Entity Framework Code First
  21. Entity Framework Code First – Advantages and disadvantages of Fluent Api vs Data Annotations [closed]
  22. EF Code First giving me error Cannot insert explicit value for identity column in table ‘People’ when IDENTITY_INSERT is set to OFF. [duplicate]
  23. EF Code First DBContext and Transactions
  24. How can I disable migration in Entity Framework 6.0
  25. How do I use Entity Framework in Code First Drop-Create mode?
  26. Many to Many Relationships not saving
  27. EF models. Navigation properties can only participate in a single relationship
  28. DbContext AutoDetectChangesEnabled set to false detecting changes
  29. Implementing recursive property loading in EF Core
  30. An object with the same key already exists in the ObjectStateManager. The ObjectStateManager cannot track multiple objects with the same key

Leave a Comment