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

Показать описание
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.
Комментарии