Exact vector search is a solid starting point. Once volume grows, approximate vector search with vector indexes a offer fast alternative with relevant results instead of exhaustive comparison on every row.

Facet is a powerful source generator tool that can help you improve your mapping code. It's easy to use, test and integrate with other libraries.

EF Core 10 introduces named query filters, allowing multiple filters per entity and selective bypass so you can disable only the filters you need.