Hi,

Query filters are a viable alternative if you're willing to put the tenant info inside the Entity classes. Most of the time, a project grows out of its initial scope and multi-tenancy is added later. With a different schema of connection being to only practical options.

I've described how to handle those options, but Query Filters are also something to keep in mind, yes:

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