Writing a specialized SQL query, and adding it directly to EF Core — code first, so the application injects it as a View on startup.
This solution belongs to a tutorial on Medium. Please follow this link:
https://medium.com/@stefried/sql-views-for-entity-framework-core-code-first-c07bfe607fa1