This C# application connects to your local PostgreSQL postgres_air database using Entity Framework Core.
-
Update the password in
PostgresAirContext.csif your database has one:"Host=localhost;Port=5432;Database=postgres_air;Username=furofo;Password=YOUR_PASSWORD_HERE" -
Restore packages:
dotnet restore
-
Run the application:
dotnet run
- Connects to the
postgres_airdatabase on localhost:5432 - Queries data from the
postgres_airschema tables:airportaircraftflightpassenger
- Displays sample records from each table
- Npgsql.EntityFrameworkCore.PostgreSQL - PostgreSQL provider for EF Core
- Microsoft.EntityFrameworkCore.Design - EF Core design-time tools