Dapper gives you speed and raw SQL but no CRUD scaffolding. Build a generic repository that writes the SQL for you from attribute metadata, so every entity gets full CRUD for free.
Your app is making 1501 SQL queries per request - and the code looks completely fine. Learn how to identify and fix the N+1 problem and Cartesian explosion in EF Core.