Suggestion: Add support for QueryFilters?

[nealculiner]

Would it be possible to add EF Core QueryFilter support so that I can specify filters for entities so they are created by default in the builder?

https://learn.microsoft.com/en-us/ef/core/querying/filters

[sjh37]

Hi @nealculiner

What you can do is in your <database>.tt file, set

Settings.DbContextClassModifiers = "public partial";

Take a look at the generated DB context, you will see a call to OnModelCreatingPartial, which you can provide in a partial class and implement your query filters in there.

 protected override void OnModelCreating(ModelBuilder modelBuilder)
 {
     base.OnModelCreating(modelBuilder);
     ...
     OnModelCreatingPartial(modelBuilder); // <<----------- new
 }

For example:

namespace V9EfrpgTest;

public partial class V9EfrpgTestDbContext
{
    partial void OnModelCreatingPartial(ModelBuilder modelBuilder)
    {
        modelBuilder.Entity<Car>().HasQueryFilter(p => p.CarMake != string.Empty);
    }
}

[nealculiner]

Thanks @sjh37 I'll explore your suggestion.