MySQL + EF Core + ASP.NET Core Web API + CRUD + Load Related Data + Views + Stored Procedures

Hey Programmers,
In this video, I am showing how you can quickly scaffold your database into models and load related data, call stored procedures and get data from views from MySQL Database for asp.net core web API project.

GitHub Link – Source Code:
https://github.com/CuriousDrive/EFCore.AllDatabasesConsidered

Steps :
Add Connection String :
Server=localhost;Database=Northwind;Uid=root;Pwd=root

Packages to install :
dotnet add package Microsoft.EntityFrameworkCore.Design
dotnet add package Pomelo.EntityFrameworkCore.MySql

Install & Update dotnet EF tool :
dotnet tool install –global dotnet-ef
dotnet tool update –global dotnet-ef

Scaffold MySQL Database :
dotnet ef dbcontext scaffold Name=NorthwindDB Pomelo.EntityFrameworkCore.MySql –output-dir Models –context-dir Data –namespace Northwind.Models –context-namespace Northwind.Data –context NorthwindContext -f –no-onconfiguringdotnet add package Microsoft.AspNetCore.Mvc.NewtonsoftJson

#MySQL #EFCore #ASPNETCore #Web #API #CuriousDrive #WeLoveCoding

Join this channel to get access to perks:
https://www.youtube.com/channel/UCetyodKOWGk5H6FoKoFnkZw/join

Subscribe here – https://www.youtube.com/channel/UCetyodKOWGk5H6FoKoFnkZw
Talk to us on – https://www.twitch.tv/curiousdrive

Like our page – https://www.facebook.com/curiousdrive/
Follow us on – https://twitter.com/curious_drive
Follow us on – https://www.instagram.com/curiousdrive/

Make a donation – https://www.paypal.me/curiousdrive
Be a member – https://www.patreon.com/curiousdrive