Filter all queries (trying to achieve soft delete)

by

Can’t test the exact API, but the general approach would be to create a constrained generic method and call it via reflection:

public static class EFFilterExtensions
{
    public static void SetSoftDeleteFilter(this ModelBuilder modelBuilder, Type entityType)
    {
        SetSoftDeleteFilterMethod.MakeGenericMethod(entityType)
            .Invoke(null, new object[] { modelBuilder });
    }

    static readonly MethodInfo SetSoftDeleteFilterMethod = typeof(EFFilterExtensions)
               .GetMethods(BindingFlags.Public | BindingFlags.Static)
               .Single(t => t.IsGenericMethod && t.Name == "SetSoftDeleteFilter");

    public static void SetSoftDeleteFilter<TEntity>(this ModelBuilder modelBuilder) 
        where TEntity : class, ISoftDeleteModel
    {
        modelBuilder.Entity<TEntity>().HasQueryFilter(x => !x.IsDeleted);
    }
}

Now you can use something like this inside your OnModelCreating:

foreach (var type in modelBuilder.Model.GetEntityTypes())
{
    if (typeof(ISoftDeleteModel).IsAssignableFrom(type.ClrType))
        modelBuilder.SetSoftDeleteFilter(type.ClrType);
}

More Related Contents:

  1. How to add the same column to all entities in EF Core?
  2. Could not load file or assembly Microsoft.Extensions.DependencyInjection.Abstractions, Version=1.1.0.0
  3. Entity framework EF.Functions.Like vs string.Contains
  4. Entering keys manually with Entity Framework
  5. Many-to-many self referencing relationship
  6. navigation property should be virtual – not required in ef core?
  7. How to instantiate a DbContext in EF Core
  8. auto create database in Entity Framework Core
  9. Dynamically changing schema in Entity Framework Core
  10. How to unapply a migration in ASP.NET Core with EF Core
  11. Cascade deleting with EF Core
  12. Include with FromSqlRaw and stored procedure in EF Core 3.1
  13. How to seed in Entity Framework Core 2?
  14. How to auto create database on first run?
  15. The LINQ expression could not be translated and will be evaluated locally
  16. EF Core queries all columns in SQL when mapping to object in Select
  17. Entity Framework | Sequence contains more than one matching element
  18. Unable to edit db entries using EFCore, EntityState.Modified: “Database operation expected to affect 1 row(s) but actually affected 0 row(s).”
  19. Working with SQL views in Entity Framework Core
  20. How to refresh an Entity Framework Core DBContext?
  21. Unit testing with EF Core and in memory database
  22. EF models. Navigation properties can only participate in a single relationship
  23. Entity Framework Core: `SqlNullValueException: Data is Null.` How to troubleshoot?
  24. Cannot find command ‘dotnet ef’
  25. ef core doesn’t use ASPNETCORE_ENVIRONMENT during update-database
  26. How to get user information in DbContext using Net Core
  27. How should I manage DbContext Lifetime in MVC Core?
  28. Implementing recursive property loading in EF Core
  29. How to set Identity Seed value in code-first?
  30. How to resolve .net core build error NETDSDK1061 and warning MSB3277

Leave a Comment