How to Create ASP.NET Core 3.0 React SPA with Secure Membership using MySQL Database in 20 Minutes
Feb 16, 2022
This tutorial uses .NET Core 3.0. Also proven to work on .NET Core 3.1 as well!
The web app has React as front end, MySQL as Database layer where the ASP.NET Identity Server 4 membership related schema will be migrated to.
Detailed Article: https://bit.ly/2zPN385
Full Code on Github Repo : http://bit.ly/2LWgacA
00:00 Introduction
00:55 Create ASP.NET Core ]Project
02:03 Configure Project creation with React & Authentication
03:19 Delete MSSQL Server Database Migrations Directory
04:10 Uninstall Microsoft.EntityFrameworkCore.SQLServer
04:40 Install Pomelo.EntityFrameworkCore.MySql
05:50 Update all NuGet package dependencies
06:53 Update appsettings.json Connection String for MySQL database
09:07 Update Startup.CS file to use to MySQL
10:10 Build the solution
11:26 Pre-checks before creating migrations or MySQL
12:11 Add Migration to create Membership Schema scripts for MySQL
13:13 Update Database to have ASP.NET Core Membership tables in MySQL
14:07 Verify MySQL database for membership tables
Show More Show Less 