PoC to try to use PostGresql with .NET Core 2.1.
- Create an ASP.NET Core 2.1 MVC Web Project in Visual Studio
- Change Authentication to allow support for Individual User Accounts
- Create Models
- Add DbSet of Models to ApplicationDbContext
- Add NuGet packages for Npgsql
- Change service in startup to use Npgsql instead of SQL Server
- Generate Controller for Foos
- Modify POST controller in Foos
- Add connection string to appsettings.json
- Run "Add-Migration InitialCreate" in NuGet Package Console
- Run "Update-Database" in NuGet Package Console
- Secret Manager stores secret for DbPassword. The password is not encrypted.