DEV Community

loading...
Cover image for Creating ASP.NET Core 3.0 React SPA with Entity Framework Core Identity Server for MySQL Database in 20 Minutes

Creating ASP.NET Core 3.0 React SPA with Entity Framework Core Identity Server for MySQL Database in 20 Minutes

windson profile image windy Updated on ・1 min read

This tutorial uses .net core version 3.0 The web app has react as front end, MySQL as Database layer where the asp.net membership related schema will be migrated to.

Pre-Requisites:
Microsoft Visual Studio 2019 Community Edition

.net core 3 https://dotnet.microsoft.com/download/dotnet-core

MySQL Tools for Visutal Studio https://dev.mysql.com/downloads/windows/visualstudio/

mysql-for-visualstudio-1.2.9.msi (https://dev.mysql.com/downloads/windows/visualstudio/)

Configurating ASP.NET Membership web app for MySQL
Step 1:
Delete Migrations Directory under the Data Directory

Step 2:
Uninstall the package Microsoft.EntityFrameworkCore.SQLServer Install the package Pomelo.EntityFrameworkCore.MySql

Step 3:
Create db in MySql

CREATE SCHEMA reactmembership;

Step 4:
Update value of DefaultConnection in appsettings.json to

server=localhost;port=3306;database=reactmembership;user=root;password=p@$$w0Rd;CharSet=utf8

Step 5:
In Startup.cs file update ConfigureServices method to replace UseSqlServer with UseMySql

Step 6:
Tools -~ Nuget Package Manager -~ Package Manager Console

In Visual Studio, use the Package Manager Console to scaffold a new migration and apply it to the database:

Add-Migration [migration name]
Update-Database

Full Code on Github Repo : http://bit.ly/2LWgacA
Video Tutorial : http://bit.ly/2rfxVN1

Discussion (0)

Forem Open with the Forem app