Configuring EF Core with PostgreSQL in ASP.NET Core (full walkthrough)

A complete guide to setting up Entity Framework Core with PostgreSQL, from an empty ASP.NET Core project to a working, migrated database.

We cover:

• Installing the Npgsql EF Core packages
• Creating and configuring AppDbContext
• Setting up the connection string
• Running your first migration and updating the database
• Using AppDbContext in your services through dependency injection
• Adding a new column with migrations