Chapter-5: .NET Core Web API CRUD Operations Using Entity Framework Core| Microservices Architecture

preview_player
Показать описание

You can also find the source code for the project on my GitHub repository:

This course aims to provide you with a clear understanding of how a clean and simple architecture should be applied to .NET Core Web APIs within a Microservices framework.

In this session, we'll be diving into the following topics:

1. **SQL Server Database Project**
- Establishing a New Git Repository for the Database Project
- Cloning the Git Repository
- Managing Files with .gitignore and .gitattribute
- Creating a SQL Server Database Project
- Structuring the Database Project's Folders
- Crafting Files for Tables, Stored Procedures, and Lookup Data
- Crafting Post Deployment Script Files
- Crafting Pre Deployment Script File
- Writing a Script for Feedback Table with Primary Key
- Scripting Lookup Data
- Sample Change Script File
- Publishing SQL Database Locally
- Committing Changes to Remote Git Repository

2. **Entity Framework CRUD Operations**
- Discussing the Flow of API Requests
- Installing NuGet Packages for Entity Framework Core
- Setting Up Dependency Injection
- Configuring Entity Framework Core DbContext
- Creating Repository and Interface
- Implementing Read Operation for the GetFeedbacks Endpoint
- Implementing Read Operation for the GetFeedbackById Endpoint
- Implementing Create Operation for the CreateFeedback Endpoint
- Implementing Delete Operation for the DeleteFeedback Endpoint
- Implementing Update Operation for the UpdateFeedback Endpoint
- Mapping Database Entities to DTO Models
- Adding Exception Handling in the Service Class
- Enhancing Swagger Documentation at Endpoint Level
- Employing Automapper for Reverse Mapping in Create Endpoint
- Testing API Endpoints Using Swagger
- Discussing Basic API Best Practices

In these segments, you'll delve into SQL Server projects, database scripting, and practical Entity Framework Core operations for your API.
Рекомендации по теме
Комментарии
Автор

Many things are so strange...but I am happy to know that, everything so useful...

HaoNguyen-kmxj
Автор

Thanks for the useful content! Is there any chance to make a video where you can demo the use of external services instead of a database?

Lemraj
Автор

The change script file is one line too long....and can you comment this line into youtube???

HaoNguyen-kmxj
Автор

Thanks for your efforts, is the source available for free?

cyrildouglas
welcome to shbcf.ru