@manhng

Welcome to my blog!

IS4-PostgreSQL

March 2, 2021 15:21

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/

https://stackoverflow.com/questions/34343599/how-to-seed-users-and-roles-with-code-first-migration-using-identity-asp-net-cor

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

https://www.c-sharpcorner.com/article/tutorial-use-entity-framework-core-5-0-in-net-core-3-1-with-mysql-database-by2/

PostgreSQL to MS SQL Server

https://www.michalbialecki.com/2020/07/17/adding-an-entity-framework-core-5-to-an-existing-database/

EF Core Example

https://github.com/khalidabuhakmeh/ef-core-entertainment

Categories

Recent posts