CRUD Operations Using Database First Approach In Entity Framework Core 6 and ASP.NET Core MVC 6

This tutorial is on CRUD operations using database first approach in Entity Framework Core 6 and ASP.NET Core MVC 6. This approach uses EF Core 6 libraries to connect to a SQL server database in the backend. The software used for this tutorial are Visual Studio 2022, .NET core 6, C# 10 programming language, SQL server express edition and SQL Management studio. All the links to download these software are provided below.

Do you want to learn how to use and interact with the ChatGPT AI language model, one of the most powerful and versatile natural language processing tools in the world? If yes, then you should check out this amazing course that will teach you everything from the basics to the advanced features of ChatGPT. Click on this link to get started and enjoy a special discount from me:

Download the source code for this project from below location:

Visual studio 2022 download link:

SQL server express edition:

SQL Management Studio 2019:

----Contents of this Video-----

0:00 Intro
1:00 Create new ASP.NET Core MVC project
1:46 Create SQL Server Database
5:25 Add nuget packages
6:59 Create Model and DBcontext objects
10:01 Add connection string
13:19 Add Controller
14:04 Update Layout page
15:00 Run the app

[tutorpraveen]

Please subscribe to the channel and like the video. I hope you will have a great career ahead 😊.

[arsalanshaikh]

I was trying to connect my database for 2 days now and was unable to do it. Then i found this gem of a video. Thank you so much for making our lives easy sir.

[imadkhan]

Thank You so much i was trying from the past 1 week to connect my database but every time error was occurring during the process then i found this video i my problem is solved so thank you soo much! ❤

[MarkInChicago]

Great video! Thanks!. Could you create a part two where you add a couple of child tables in the databasse and then show how you update the code so it can use the child tables?

[johnes]

Thank you for your tutorial. I am confuense how to use db connection string, but your video is show how to use. thank you again.

[md.abdullahalmamun]

Thanks for creating this video. Definitely it's a great video with clean code. Could you please create a video how can we add another or multiple table and also update models in existing project?

[RAJAKALIRAJAN]

Great tutorial, I have entered to dotNETCore Developer community, Thank you so much

[thirishwehlaing]

Thank you so much.Your tutorial is the only one perfect for me, sir;

[Er.MeetPatel]

One of the most amazing video i have ever vatched

[mukeshchaudhari]

Neat and clean tutorial.. Thank you so much. Please make more tutorial covering complete dot net core 6 with entity framework

[muazkhan]

Very Help Full Video For Me Thanks A lot

[uh_oh_letsgo]

Super well done and informative. Thank you.

[sanD-xqnb]

Just in case you try to use with packages version 7.0.0, the ConnectionStrings have to include "Encrypt=false;". I wasted almost one day to get to this, because the ConnectionStrings like the video didn't work.

[QuantumByts]

Thank you. Very concise and informative.

[wilsonochuko]

Thanks so much. This video is really helpful.

[chandrakantmusale]

video is so helpful sir, but i have one query what if i add any column then where we have to make changes in visual studio

[theprimecoder]

Thanks, this tutorial vid really helped me a ton

[delightful]

Need Get Data from Multiple Tables with join Query, DB First Approach, MVC, Not Repository Parrten

[shivaainfo]

Thank you so much. It's working fine.

[Mattyus-Web]

very good bro I have a problem, I have my database but I have a column of dates so it shows me the time and date and what I want is only to have the date in my table I wanted to modify it in models but it does not work since net 6 It already has added as DateOnly if you can help me