Move to Entity Framework core

## What
Move away from Dapper to

## Why
To get away from the bloat, streamline queries and make the more readable.

# Definition of done
- [ ] Clean up handler
- [ ] Make one save not multiple in handler
- [ ] Create Extensions for queries and commands if needed
- [ ] Create Service for query and commands if needed
- [ ] Make sure All endpoints works as intended
- [ ] Make sure tests work as intended
- [ ] Remove Dapper package
- [ ] Remove Repositories

Start by locating the handlers, repositories, endpoints, tests, and current Dapper usage mentioned in the issue. Map how queries and commands currently save data before deciding whether extensions or services are needed. Done means all endpoints and tests still work, handlers perform one save, Dapper and repositories are removed, and the Entity Framework Core migration is complete.

Written by the indexing model from the issue text.