Building Minimal APIs with ASP.NET Core 8 and Dapper

Course Curriculum

Chapter 1: Introduction

Lecture 1: Introduction

Lecture 2: Web APIs

Lecture 3: Architecture of Our Solution

Lecture 4: Web APIs Architectural Styles – REST

Lecture 5: SOAP

Lecture 6: GraphQL

Lecture 7: What is .NET?

Lecture 8: What is C#?

Lecture 9: What is ASP.NET Core?

Lecture 10: Controllers vs Minimal APIs

Lecture 11: Summary

Lecture 12: Github Repository

Chapter 2: Creating the Web API

Lecture 1: Introduction

Lecture 2: Installing .NET

Lecture 3: Installing Visual Studio

Lecture 4: Installing Visual Studio Code

Lecture 5: Installing SQL Server

Lecture 6: Installing Postman

Lecture 7: Creating the Web API with Visual Studio

Lecture 8: Creating the Web API with the dotnet CLI

Lecture 9: Solutions and Projects

Lecture 10: Nullables and Implicit Usings

Lecture 11: The LaunchSettings File

Lecture 12: Configuration Providers – AppSettings

Lecture 13: The Program Class

Lecture 14: List of Genres

Lecture 15: Summary

Chapter 3: REST Principles

Lecture 1: Introduction

Lecture 2: Client-Server Separation – CORS

Lecture 3: Visualizing the CORS Error

Lecture 4: Enabling CORS Configuration in ASP.NET Core

Lecture 5: Configuring CORS in Endpoints

Lecture 6: Not Using State

Lecture 7: Introduction to Cache

Lecture 8: Implementing OutputCache

Lecture 9: Layered-System

Lecture 10: Documenting the Web API with Swagger

Lecture 11: Summary

Chapter 4: Introduction to Dapper

Lecture 1: Introduction

Lecture 2: What is a Database?

Lecture 3: Creating a Database

Lecture 4: Creating the Genres Table

Lecture 5: Query For Inserting Data

Lecture 6: What is ADO.NET?

Lecture 7: What is Dapper?

Lecture 8: Communicating with the Database – The Connection String

Lecture 9: Installing Dapper

Lecture 10: Inserting Genres

Lecture 11: Selecting Genres

Lecture 12: Cleaning Up the Cache

Lecture 13: Ordering Records

Lecture 14: Updating Genres

Lecture 15: Deleting Genres

Lecture 16: MapGroup

Lecture 17: Going From Lambda Expressions to Named Methods

Lecture 18: Group of Endpoints per Class

Lecture 19: DTOs

Lecture 20: AutoMapper

Lecture 21: Introduction to Stored Procedures

Lecture 22: Stored Procedures with Parameters

Lecture 23: Summary

Chapter 5: Actors, Movies and Comments

Lecture 1: Introduction

Lecture 2: Creating the Actor Entity

Lecture 3: Actors CRUD

Lecture 4: Endpoint for Inserting Actors

Lecture 5: Preparing the App to Store Images

Lecture 6: Azure Storage

Lecture 7: Saving Files Locally

Lecture 8: Getting Actors

Lecture 9: Filters

Lecture 10: Pagination

Lecture 11: Implementing Pagination

Lecture 12: Updating Actors

Lecture 13: Deleting Actors

Lecture 14: Creating the Movie Entity

Lecture 15: Movies CRUD

Lecture 16: Endpoint for Inserting Movies

Lecture 17: Selecting Movies

Lecture 18: Updating Movies

Lecture 19: Deleting Movies

Lecture 20: Creating the Comment Entity

Lecture 21: Comments CRUD

Lecture 22: Endpoint for Inserting Comments

Lecture 23: Getting the Comments of a Movie

Lecture 24: Updating and Deleting Comments

Lecture 25: Getting a Movie and its Comments

Lecture 26: Configuring a Many-to-Many Relationship between Genres and Movies

Lecture 27: Assigning Genres to a Movie

Lecture 28: Creating an Endpoint to Assign Genres

Lecture 29: Configuring a Many-to-Many Relationship between Actors and Movies

Lecture 30: Assigning Actors to a Movie

Lecture 31: Creating an Endpoint to Assign Actors

Lecture 32: Getting a Movie and its Genres and Actors

Lecture 33: Summary

Chapter 6: Validations and Error Handling