Migrated to .NET 9

Boilerplate has been migrated to .NET 9 💪

Additionally:

- added MS OpenAPI

- replaced Swagger with Scalar

- replaced MySQL provider from Pomelo with MySQL Oracle provider

- added health checks to docker compose

- migrated to xunit.v3