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:
/channel/UCetyodKOWGk5H6FoKoFnkZw/join
Subscribe here - /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