ASP.NET Core 6 Web API Using Entity Framework Core 6 Database First Approach

ASP.NET Core 6 Web API Using Entity Framework Core 6 Database First Approach

Learn how to build and test a simple API that can perform CRUD operations and implements GET,POST, PUT and DELETE REST API operations. In this lesson, you will learn how to create an API using ASP.NET Core 6, create a database using SQL Server 2019, Scaffold the database using Entity Framework and then configure the API to ensure that it is secure and efficient.

This tutorial teaches the basics of building a web API with ASP.NET Core.

In this tutorial, you learn how to:
- Create a web API project.
- Scaffold a database context and table model classes.
- Scaffold a controller with CRUD methods.
- Configure routing, URL paths, and return values.
- Call the web API with Postman.

This video gives an introduction to Database First development using Entity Framework. Database First allows you to reverse engineer data models from an existing database.

What you need?
Visual Studio 2022 with the ASP.NET and web development workload.

Learn Full API Development from these courses:

0:00 - Introduction
00:05:17 - Create ASP.NET Core 6 API Project
04:24 Tour API Project
09:44 - Add CORS Policy
14:04 - Setup Database Tables
23:55 - Scaffold Database using Entity Framework Core
39:46 - Scaffold and Test API Controllers and Endpoints
1:05:25 - Adding AutoMapper and Data Transfer Objects (DTOs)
1:32:04 - Scaffold and Test Controller with Relational Data Tables
1:36:10 - Configure AutoMapper and DTOs for Related Data
1:59:05 - Add Project to GitHub

[TrevoirWilliams]

Learn Full API Development from these courses:

[jonah]

Very thorough intro guide! I had limited knowledge going in but I feel like a wizard now, thanks!

[ronaldjohnson]

Thank you Trevoir, excellent tutorial.

[sergkapitan]

Explanaition part is good:) Can you tell why the quality of picture is so so bad??? I cannot realy recognize almost anything ...

[harpesiri]

great content and clear explanation..Thanks

[jessmathew]

This video is very informative, and i have a doubt if in case i need both books details and authors details what should be done? One class is depending on another. So what change is to be made?

[ahmadyamout]

Thank you dear for your hard work . Dear If I want to update the existing db should I remove the data folder and re type the Scaffold dbcontext again in the package manager console?

[forgiveandforget]

You didn't put the author Id in the create book dto while it is put in the read-only, detail and the real data model
How can I add a book without adding the author of it

[hamzahassani]

thanks man for all your work
please do a practical course for DDD

[arunakumari]

How to get and use appsettings.json and cachesetting.json static data in the project ?

[iKadheya]

I have a problem, when I publish this to IIS the conenection to the database breaks :( is there something to configure to iis ?

[aricwilliamsdeveloper]

hey! what course can i take to get good course on save data to database and retrieve data from database , login and registration... I can make an app, but it loose data after refresh. Like on udemy it remembers everything about me when i login. I want to make a software as a service app

[kawkabsuhail]

an error emerged when I ran the project swagger localhost refused connection ....How can I solve it

[harishbhor]

can u explain how to solve cors policy error in entity framework

[forgiveandforget]

What is the next video should I watch to build mvc model and connect it to this api