Web API con .NET CORE y Swagger + Dapper + SQL Server

Learn to build robust Web APIs with .NET! This comprehensive course guides you through the entire process, from setting up your development environment to deploying a fully functional API. You'll gain practical skills in database design using SQL Server and leveraging Swagger for efficient testing.

Here's a detailed look at what you'll learn:

• Getting Started:

  • Course Overview: Understand the curriculum and learning objectives.
  • Environment Setup: Install Visual Studio and the SQL Server database engine.
  • SQL Server Management Studio: Learn to install and utilize the essential management tool.

• Building Your Web API Project:

  • Project Creation: Create a new .NET Web API project.
  • Dependency Injection: Master the principles of dependency injection for cleaner, more testable code.
  • Implementing Dependency Injection: Apply dependency injection within your project.

• API Request Handling (GET, POST, PUT, DELETE):

  • GET Requests & DTOs: Understand GET requests and how to use Data Transfer Objects (DTOs) for data exchange.
  • GET with Code Search: Implement GET requests to retrieve data based on specific codes.
  • POST Request Implementation: Learn to create a mechanism for handling POST requests and data creation.
  • PUT Request Implementation: Build a mechanism for handling PUT requests and updating existing data.
  • DELETE Request Implementation: Implement a mechanism for handling DELETE requests and removing data.

• SQL and Dapper Integration:

  • SQL & Dapper Fundamentals: Introduction to SQL and the Dapper library for efficient database interaction.
  • Dapper Implementation: Practical examples of using Dapper to interact with your SQL Server database.
  • Stored Procedures: Learn to utilize stored procedures for complex database operations.

• Database Persistence:

  • Table Creation: Design and create your Employees table in SQL Server.
  • CRUD Operations with Dapper: Implement Create, Read, Update, and Delete (CRUD) operations for managing employee data using Dapper.
  • Retrieve Single/Multiple Employees: Learn to fetch employee data using Dapper.
  • Update Employee Records: Implement functionality to modify existing employee information.
  • Delete Employee Records: Implement functionality to remove employee records from the database.

• Asynchronous Programming:

  • Asynchronous Concepts: Understand the fundamentals of asynchronous programming in .NET.
  • Asynchronous Interfaces & Services: Design interfaces and services using asynchronous methods.
  • Controller Adaptation: Adapt your controllers to utilize asynchronous programming patterns.

• Logging:

  • Logging Package Integration: Add a logging package to your project for comprehensive error tracking.
  • Error Handling with Logging: Implement error handling mechanisms and log errors for debugging.

• Authentication with JWT:

  • JSON Web Tokens (JWT): Learn the theory behind JWT for secure API authentication.
  • Database Structure for Users: Design a database schema for storing user information required for authentication.
  • Integrating JWT into Your API: Implement JWT authentication to protect your API endpoints.
  • Swagger Header Configuration: Learn how to add headers to your Swagger documentation.

• Updates & Enhancements:

  • Base64 Image Handling: Learn to encode and decode images in Base64 format.
  • .NET Updates: Guidance on updating Visual Studio to use .NET 7, C# 11, .NET 8 and C# 12.
  • SQL Server Updates: Instructions for installing SQL Server 2022 and Management Studio.
  • Database Restoration & Project Adaptation: Learn how to restore your database and adapt your project to the latest SQL Server version.

• Conclusion & Resources:

  • Course Summary: Key takeaways and next steps.
  • Student Questions & Answers: Addressing common questions and providing further support.