MySQL + EF Core + 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: /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

Category