- Auto create Context by Visual Studio. (Connected Services -> Add -> PostgreSQL)
- Install NuGet package : Microsoft.EntityFrameworkCore
- Install NuGet package : Npgsql.EntityFrameworkCore.PostgreSQL
- Add code :
builder.Services.AddDbContext<LocationAppContext>(options =>
options.UseNpgsql(System.Environment.GetEnvironmentVariable("POSTGRESQL_STRING") ?? throw new InvalidOperationException("Connection string 'LocationAppContext' not found."),
options => options.EnableRetryOnFailure().SetPostgresVersion(new Version(9, 6))
));