Database Application

A personal project which aims to create an API-driven database application, which is intended to serve multiple projects.
Note: this project is continuously being updated; progress is tracked here.

Database Migrations

In order to propagate changes to the database from entity framework core, Microsoft.EntityFrameworkCore.Tools is installed into the startup project.

This exposes a set of commands in the package manager console:

Add-Migration <desiredMigrationName>
Update-Database

Or alternatively, install the dotnet entity framework CLI:

dotnet tool install --global dotnet-ef

And add migrations & update the database as follows:

# add migration
dotnet ef migrations add <desiredMigrationName> --startup-project .\src\Database --project .\src\Database.Core
# update database
dotnet ef database update --startup-project .\src\Database --project .\src\Database.Core

Or just use the powershell scripts provided.

Docker & Heroku Deployment

The application is deployed via a Docker container to Heroku.
The Dockerfile is generated through Visual Studio Container Tools (Right-Click Host Project > Add > Docker Support).

---