IS4-PostgreSQL (edit)
https://deblokt.com/2020/01/24/03-identityserver4-ef-with-postgresql-net-core-3-1/
https://github.com/Deblokt/IdentityServer4Demos.NETCore31
https://www.everestparked.com/post/integrating-and-using-identity-in-aspnet-core-using-postgre-sql
Npgsql.EntityFrameworkCore.PostgreSQL
Npgsql.EntityFrameworkCore.PostgreSQL.Design
https://www.enterprisedb.com/postgres-tutorials/10-examples-postgresql-stored-procedures/
https://codingsonata.medium.com/deploy-asp-net-core-web-api-on-iis-f75e755a6402
EF Core 5.0
https://www.c-sharpcorner.com/article/entity-framework-core-5-0-an-introduction-with-whats-new/
https://www.learnentityframeworkcore5.com/migrations-in-ef-core
https://blog.jetbrains.com/dotnet/2020/11/25/getting-started-with-entity-framework-core-5/
Seeding
http://www.binaryintellect.net/articles/5e180dfa-4438-45d8-ac78-c7cc11735791.aspx
https://alexcodetuts.com/2019/05/22/how-to-seed-users-and-roles-in-asp-net-core/
To work with EF Core 5 we need to install NuGet packages
- Microsoft.EntityFrameworkCore
- Microsoft.EntityFrameworkCore.Design
- Microsoft.EntityFrameworkCore.SqlServer
SQLite
- Microsoft.EntityFrameworkCore
- Microsoft.EntityFrameworkCore.Design
- Microsoft.EntityFrameworkCore.Sqlite
MySQL to MS SQL Server
PostgreSQL to MS SQL Server
https://www.michalbialecki.com/2020/07/17/adding-an-entity-framework-core-5-to-an-existing-database/