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

preview_player
Показать описание
Hey Programmers,

GitHub Link - Source Code:

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:

Рекомендации по теме
Комментарии
Автор

Why can't all tutorials just work like this one!! Thanks for this, it has saved me sooo much time

hencoeloff
Автор

Thank you for sharing your knowledge, Quality free short tutorial, Hand an Interview where they asked about everything you in this video, I had no Idea I was that easy to work with views and procedures ❤

HelloWorld-thvb
Автор

Thank you so much !!
You really saved my life.

PoMPaM
Автор

Thank you so much. Excellent Video. Could you tell me how add "adding dbcontext service" item to toolbox, I found my vs2022 toolbox has no such items.

lihongwang-stxx
Автор

Amazing video. Educative and powerful video.

issakahniiarmahtagoe
Автор

Excelent video!!
I'm having issues when creating the ProductController (minute 14:20). The error says "There was an error running the selected code generator. Package restore fail. Rolling back package change for <My Project>".

Do you have any idea of what is happening?

guidorusso
Автор

Pls make a video about your custom powershell

mersy
Автор

User
when we are scaffold our database views are not present here in dotnet core?

muhammadfaizan
Автор

bro how can i connect mt4 account into my website . so whatever i will trade it will show me as performance or graph in my website dashboard

MoosaMughal.
Автор

hello! What if i update my database, can i rerun the code for it to update the models and dbcontext or do i have to do extra steps? and as usual i love your videos!

nekoniwaa
Автор

Hi

Can you please share the any reference of mvc core using mysql of authorization bearer token concept

sweetysnehith
Автор

all my api's return the index.html file. do you know what could be the problem?

tundra_subzero
welcome to shbcf.ru