To build the project from the source you need .NET 6.0, C# 10. The prefered IDE is Visual Studio 2022, although it is not required.
Project currently uses Entity Framework Core 6.0 nuget packages.
The file appsettings.json contains all our current connection strings. By default the Default connection string is used, although that can be changed in the Program.cs file (builder.Configuration.GetConnectionString("Default") passes the name of connection string to be used).
Alternatively if evniromental variable DATABASE_URL is set this will be used and postgresql connection string will be built instead.
To generate your own connection local string open SQL Server Objective Explorer, select the connection you want to use and right click on Properties. Use the connection string shown to you in General.
If you want to use local postgre database launch application with -provider postgre argument.
To apply migrations use
Update-Database
with optional argument of -Migration to apply specific migration instead of newest.
To revert a migration use the same command with -Migration set to previous migration or run
Update-Database -Migration 0
to revert all migrations.
To generate migration SQL script run
Script-Migration
with optional argument of -Migration to target specific migration.
To create a migration run
Add-Migration [name] -Project Patronage.Migrations
Additionally to add PostgreSQL migration run
Add-Migration Heroku -Project Patronage.MigrationsPostgre -Args "--provider postgre"
To remove a migration run
Remove-Migration
with optional argument of -Migration pointing to the specific migration.
To list migrations run
Get-Migration
All the commands work in Visual Studio's Packet Manager.
Every command listed above can be run on local postgre database when provided with -provider postgre argument.