ASP.NET Core Web API + Entity Framework Core : Database First - EP01

Hey Coders,

You can download SQL express from. Please find the link below.
And you can follow these steps if you are using Ubuntu -

In this #EntityFramework tutorial, I am explaining how you can connect to your SQL express database and how you can run Entity Framework Core tool to scaffold the database. It's also known as #DatabaseFirst approach.

Content -
1. What's Database First?
2. Creating ASP.NETCore #WebAPI
3. Running command Scaffold-DbContext
4. Generating DBContext and Models
5. Performing CRUD Operations

Scaffolding Command -
Scaffold-DbContext "Server=.\SQLExpress;Database=BookStoresDB;Trusted_Connection=True;" Microsoft.EntityFrameworkCore.SqlServer -OutputDir Models

#CuriousDrive #WeLoveCoding

[CuriousDrive]

Thanks for watching, please share with your friends :)

[svantepanter]

Great tutorial, thank you! Right what I was looking for. When researching this topic (Web API) there is often a lot about interface and repository. The approach you showed is more easy to grasp for a beginner.

[Lolatyou]

Starting my own business, have a couple years of coding experience but not in all the right places yet. This and your blazor videos will help out, thanks. Hope your channel keeps growing as blazor gets more popular.

[paul]

Thanks for the clear tutorial. I normally use SQL Server with stored procs and data access layers. This EF is all new to me so it's very useful.

[stoic]

This is awesome, loved your vdo, easy to understand, to the point, thank you so much.

[yogeshkulkarni]

This is a good tutorial. I am yet to watch remaining videos in the list, but I must say that the beginning is good :) Thank you..

[simonroyjonesuk]

Brilliant video. Very clear and I learnt a lot. Thank you.

[kumaresanettiyannan]

Awesome tutorial.. crisp and clear information. thank you.

[WikkiOnIlluminati]

Awesome video series.
Best and quick learning.
thanks

[codingwithelhacen]

New Subscriber here. Thank you for sharing this video. Great explanation! Please keep up the great work. Followed through with no problem.

[ritiarya]

Thank you so much, this video is amazing from all videos which are uploaded on youtube really thank you so much...

[guillermoruiz]

Hi, this is the first video that I see and I really liked it, you have a new subscriber. If you fix a new project, use DataBaseFirst or CodeFirst?

[ersingencer]

so simple and great tutorial thank you so much

[thainguyenphuong]

Video is very important to me. Thank you bro!

[BudiSantoso-ercq]

Great tutorial, thanks very much bro..

[arifjaved]

Probably the best video series to learn reverse engineering in . Net core web api.. Thank you so much sir.. If possible please make videos where we will have to join tables in db first approach using ef core

[shaikhakhtar]

Really nice video,
Please make videos on step by step project implemention too

[waqasriaz]

A comprehensive video series. Loved your videos.


There were two abruptions I faced when following your video series and can be improved:
1.
The user login method wasn't created when using visual studio > add controller > scaffold new item.

I presume you made it backstage and later in your uploaded videos, it suddenly appeared to viewers.
Even, the scaffolding part was missing.

2.
The link to your GitHub project > 'code.txt' file doesn't contain the code you showed in the videos.



For the students, the video series is worth giving time. I learned a lot in such a short video series about Web API and associated tooling to professionally handle this project. The knowledge given in this series highly overrides the above abruptions being pointed.

[ahmetselcukzengin]

Thanks a lot, great tutorial and reminder (:

[alfonsovillegas]

Thanks for this. I hope you can cover on future parts how to create an independent method for each CRUD operation instead of using the same method for all operations... And how to call each method from one on the UI technologies you mention at the begining.