Setting up PostgreSQL Database

Assuming you've already got PostgresSQL and pgAdmin installed, then here's a quick reminder to setting up the database connection in .NET 6:

• Remove the 'Migrations' folder within the 'Data' folder of the solution explorer.
  • These default instructions are for MSSQL.
• Get Npgsql.EntityFrameworkCore.PostgreSQL with the NuGet Package Manager.
  • This package gives .NET access to PostgreSQL.
• In Program.cs change the default '...options.UseSqlServer(...)' to '...options.UseNpgsql(...)'.
• Change "DefaultConnection" property in the appsettings.json file to correspond with the PostgreSQL Db.
  • "DefaultConnection": "Server=localhost; Port=5432; Database=(Your Db Name); User Id=postgres; Password=(Your password)".
• Type the following commands in the NuGet Package Manager -> Package Manager Console:
  • Add-migration Initial -o "Data/Migrations"
  • 'Initial' is the name of the migration
  • '-o' this option specifies the output directory
  • ' "Data/Migrations" ' is the specified output directory. We're rebuilding the Migrations folder since we deleted the default folder.
  • If migrations are kept in a different project within your solution, then set the 'Default project' drop down accordingly.
  • 
  • Update-Database
    • This builds the database from the migration.
• Check the database with pgAdmin