EF Core Query Limit Values Returned on Navigation Property
I’m building a query up before running it and trying to search something on the navigation properties. I can do that, but EF brings back everything from that navigation property, when I’d like just the items that actually matched the criteria. I believe that’s due to the use of Any(), but I’m not sure how else to write this query in a way that works. Here’s the data classes (simplified):