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:
bit.ly/3E8VEjF
Download the source code for this project from below location:
github.com/tut...
Visual studio 2022 download link:
visualstudio.m...
SQL server express edition:
www.microsoft....
SQL Management Studio 2019:
docs.microsoft...
---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
10:42 Update program.cs
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 😊.

[@arsalanshaikh2805]

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.

[@tutorpraveen]

Thanks for your kind words

[@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?

[@johnes07141]

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.

[@RAJAKALIRAJAN]

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

[@tutorpraveen]

You are welcome

[@solo6135]

Thanks man, you saved my semester!

[@tutorpraveen]

You are welcome

[@uh_oh_letsgo99]

Super well done and informative. Thank you.

[@muazkhan3529]

Very Help Full Video For Me Thanks A lot

[@tutorpraveen]

You are welcome

[@Er.MeetPatel]

One of the most amazing video i have ever vatched

[@tutorpraveen]

Thanks for your kind words

[@thirishwehlaing2274]

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

[@tutorpraveen]

You are welcome

[@QuantumByt3s]

Thank you. Very concise and informative.

[@md.abdullahalmamun6039]

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?

[@demiladetunde-ayinuola5755]

The best and shortest video

[@tutorpraveen]

Thank you

[@user-ol4nf4eg9e]

Thanks alot man!! great video!!!

[@tutorpraveen]

Thank you

[@mukeshchaudhari1100]

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

[@tutorpraveen]

Sure. Thanks for your feedback.

[@mr.versatile3760]

Magical. So well Done. Thanks.

[@tutorpraveen]

Glad you enjoyed it!

[@sanD-xq8nb]

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.

[@tutorpraveen]

New versions of packages get released frequently so the behaviour may differ a bit. Thanks for your feedback.

[@Ormusic071]

Very good explanation, thank you!!!

[@tutorpraveen]

You are welcome

[@KrishnaPrasad-rv7vh]

Really Helpful, Thank you.

[@tutorpraveen]

You're welcome!

[@wilsonochuko4691]

Thanks so much. This video is really helpful.

[@tutorpraveen]

You're very welcome!

[@theprimecoder4981]

Thanks, this tutorial vid really helped me a ton

[@delightful730]

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

[@chandrakantmusale9792]

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

[@tutorpraveen]

You have to refresh the entity framework

[@debrahodges4193]

Great video thank you!

[@tutorpraveen]

My pleasure!

[@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

[@tutorpraveen]

Thanks. In the get and set of your property you need to format the date.

[@matiowsshimeliss6726]

Thank you bro ☺

[@tutorpraveen]

You are welcome😊

[@shivaainfo]

Thank you so much. It's working fine.

[@tutorpraveen]

You are welcome

[@marcom5331]

Good,but what if I want to change the structure of the DB?

[@vmsmprogrammingclasses9737]

Please upload the video on Export data in excel file by using ASP.NET core 6.0 Web API

[@mehedihasan-kf4uy]

show error message- A connection was successfully established with the server, but then an error occurred during the login process. (provider: SSL Provider, error: 0 - The certificate chain was issued by an authority that is not trusted.) Pls help me

[@solo6135]

How did u fix it?

[@solo6135]

Just in case you haven't figure it out try something like this:
Scaffold-DbContext "Server=DESKTOP-2VRJKGU\MSSQLSERVER_VF; Database=ComprasISO810;Trusted_Connection=True; TrustServerCertificate=True" Microsoft.EntityFrameworkCore.SqlServer -OutputDir Models
Hope it helps you man!

[@rahulsharma5927]

Kindly make the video with Add Photos and cascading

[@tutorpraveen]

Ok. Thanks for your comment.

[@f54469]

why my Program.cs is different from yours?
public class Program
{
public static void Main(string[] args)
{
CreateHostBuilder(args).Build().Run();
}
public static IHostBuilder CreateHostBuilder(string[] args) =>
Host.CreateDefaultBuilder(args)
.ConfigureWebHostDefaults(webBuilder =>
{
webBuilder.UseStartup();
});
}

[@tutorpraveen]

You should use Visual studio 2022 for the latest program.cs template

[@vmsmprogrammingclasses9737]

Create a new project and write a API for Export data in Excel

[@IsmailHossain-fv1yq]

source code please

[@tutorpraveen]

github.com/tutorpraveen/Core6DBFirstCountryApp

[@mynameiskhalid3442]

why i have show this
A connection was successfully established with the server, but then an error occurred during the login process. (provider: SSL Provider, error: 0 - The certificate chain was issued by an authority that is not trusted
After this comand
Scaffold-Dbcontext "Server=.\SQLExpress;Database=HumenResourece;Trusted_Connection=True;"Microsoft.EntityFrameworkcore.SqlServer -OutputDir Models

[@Lextrack12]

Thank you