How to Configure ASP.NET Core 3.1 Angular SPA, Identity Server 4 (Authentication) with PostgreSQL

In this tutorial we will see how to configure an ASP.NET Core 3.1 web application with AngularJS SPA as front end and PostgreSQL as database with Secure User membership implementation using Identity Server 4.

You can follow along with this video tutorial as it is step by step detail providied you have following PreRequisites satisfied.

PreRequisites:
Visual Studio 2019 (Community/Professional/Enterprise Edition) v16.4.0 or higher
PostgreSQL Database Server installed. Version 11 or Higher
A browser preferrably Chrome, Firefox or IE 11 or higher
PgAdmin to access PostgreSQL Server Database
Windows 10 PC
00:00 Introduction

Steps:
00:50 Install & Access PostgreSQL on Windows 10
01:52 Update Visual Studio 2019 with .NET Core 3.1
02:12 Create ASP.NET Core 3.1 Angular application with Individual User Accounts
03:57 Delete Migrations directory
04:20 Update Connection string to point to PostgreSQL Database
05:57 Remove Microsoft.EntityFrameworkCore.SqlServer
06:17 Insall Npgsql.EntityFrameworkCore.PostgreSQL
07:03 Update all NuGet packages to support .NET Core 3.1
08:04 Update malformed .csproj file
08:27 Install Angular CLI
10:02 Add-Migration scripts
add-migration PostgreSQLIdentitySchema
11:29 Update-Database
update-database
12:33 Verify Database and ASP.NET Core 3.1 Membership tables created in PostgreSQL
13:16 Build the solution
13:22 Run the application
14:17 Register & Login to the Web Application
15:30 Check registered users in PostgreSQL database
16:06 Summary

------------------------------------------------------------------------------------------------

(っ◔◡◔)っ Share this video with your friends and colleagues and let them know you are upto date with latest tech-trends

Follow us to keep updated with latest trends in Tech:

Support:
(Appreciate your Generosity: 💸)
ETH: 0x0689Ecd747d6F4eA9CE491aD0b1734fEe62b2229

------------------------------------------------------------------------------------------------
#dotnetcore3 #dotnetcore3_1 #vs2019 #postgresql #IdentityServer4 #aspnet #dotnet #angularjs #authentication #webstartups #webapps #spa #singlepageapplication #angularjs8 #visualstudio2019

[professorengenharia]

I coudnt be hapier than now after i finish this video. Thanks a lot for your knowledgement and to pass this for us. We from Brazil like very much your content. Keep doing this. You are fuck(em português: você é foda! sinônimo de pessoa grandiosa e poderosa)

[federico]

Very good job!!! All it's clear. Thank you.

[sameerjain]

Thanks for this nice video. I had one question, can we use PostgreSQL without Entity Framework for building out APIs ?

[Parmpita]

I am getting error while i am building this default app
ts error not found the path for @angular

[abhijithsugunan]

What is the advantage that we get when we choose to create our angular application via visual studio angular template over typical angular cli ?

[taniax]

I don't find the token endpoint and the authentification route in angular .

Can you help me ?

[talhaashraf]

Good Work .. but can i get an exact date by which you will upload the whole course about angular 8 and .net core 3.1????

[ratheeshkumarps]

I am getting below error. Am i missing something?

AggregateException: One or more errors occurred. (One or more errors occurred. (The NPM script 'start' exited without indicating that the Angular CLI was listening for requests. The error output was: ))

[bilalelmursi]

Thank you ! but you need to change the video title of Angularjs to Angular

[georgibaldjiev]

The title is quite misleading. Do a quick google search next time you decide to throw around buzzwords. IdentityServer 4 is an entirely different concept from Asp.NET Core Identity Framework.