EF Core HasQueryFilter doesn't work with Count()

391 Views Asked by At

I have class Employee and child class 'User' with IsActive state. User has IsActive property. We use HasQueryFilter(e => e.IsActive) to prevent getting inactive user. When we trying call Count() it is returns all count ignoring HasQueryFilter.

class User
{
     ....
     public bool IsActive { get; set; };
}

class Employee 
{
     ...
     public User User{ get; set; };
}

...
Entity<User>(e => e.HasQueryFilter(x => x.IsActive));

...
context.Employees.Include(x => x.User).Count(); // Returns all count ignoring QueryFilter.

0

There are 0 best solutions below