--no-pluralize --use-database-names Are useful options in the "dotnet ef ... scaffold" command if you want to keep/use the database table/column names as defined in the database.
Thank you so much for adding this! My favorite comments are those that add to the value of the video / help the other watchers. Also, thanks for stopping by to check out data vids!!
Its pretty much the same as in SQL server. Here is a video on how to do it in SQL server: th-cam.com/video/fWJwVOeS3o4/w-d-xo.html Or if you prefer, here is a stackoverflow discussing it in MySQL as well: stackoverflow.com/questions/14264750/how-to-call-stored-procedures-with-entityframework (The first answer when you scroll is similar to how I do it in SQL with my video above) Best of luck, Muhammad Khalid!
@reza makvandi Yes! All you have to do is append -o Models to put it in the Models folder. This should work even if the Models folder already exists. For example: dotnet ef dbcontext scaffold "Server=localhost;User=root;Password=MyPassword;Database=partyvote" "Pomelo.EntityFrameworkCore.MySql" -o Models
I have not done this before, but a quick google search I found this article, though its not for entity framework so you will have to make adjustments: mysqlconnector.net/tutorials/connect-ssh/
Well it first gets created by going to new project and choosing a dotnet / dotnet core web project (just not a dotnet framework project). Then a couple times during the video you will see I edit this startup.cs to add things/change parts of it.
In .NET 6 there is no Startup.cs anymore. But you can maybe try docs.microsoft.com/en-us/aspnet/core/migration/50-to-60?view=aspnetcore-6.0&tabs=visual-studio
Its very helpful for developed api in old .net core 3.1 after your guidance I have to upgrade to .net 5.0
Thank you very much for this video. Very helpful. Greetings from Guatemala, Central America
Welcome! Beautiful country.
--no-pluralize --use-database-names
Are useful options in the "dotnet ef ... scaffold" command if you want to keep/use the database table/column names as defined in the database.
Thank you so much for adding this! My favorite comments are those that add to the value of the video / help the other watchers. Also, thanks for stopping by to check out data vids!!
Thank you! This was helpful to me!
I'm so glad!
sir how we call MySQL stored procedure in EF core, with parameter and without parameters?
Its pretty much the same as in SQL server. Here is a video on how to do it in SQL server: th-cam.com/video/fWJwVOeS3o4/w-d-xo.html
Or if you prefer, here is a stackoverflow discussing it in MySQL as well:
stackoverflow.com/questions/14264750/how-to-call-stored-procedures-with-entityframework
(The first answer when you scroll is similar to how I do it in SQL with my video above)
Best of luck, Muhammad Khalid!
@@DataVids thanks working, I appriciated...
Thanks - this is super helpful!
Glad to help!
Thanks for your amazing video. Is there any way to create db models inside Models folder automatically with that command?
@reza makvandi Yes! All you have to do is append -o Models to put it in the Models folder. This should work even if the Models folder already exists. For example: dotnet ef dbcontext scaffold "Server=localhost;User=root;Password=MyPassword;Database=partyvote" "Pomelo.EntityFrameworkCore.MySql" -o Models
Thanks for your video.
I have a problem to connect to my database because I have to use SSH. Can you help me how to solve this problem?
I have not done this before, but a quick google search I found this article, though its not for entity framework so you will have to make adjustments: mysqlconnector.net/tutorials/connect-ssh/
How did you create Startup.cs file
Well it first gets created by going to new project and choosing a dotnet / dotnet core web project (just not a dotnet framework project). Then a couple times during the video you will see I edit this startup.cs to add things/change parts of it.
In .NET 6 there is no Startup.cs anymore. But you can maybe try docs.microsoft.com/en-us/aspnet/core/migration/50-to-60?view=aspnetcore-6.0&tabs=visual-studio
When You wear Your shirt and I wear my shirt, does it feel like we're together?🤣🤣🤣 Datavids4life.
haha yes, yes it does. Now we need hats!
how to run developer PowerShell in VS
Create a powershell script project, or you can get the powershell tools for visual studio extension.
thankx
You are welcome!