A step-by-step guide to integrating Dapper (a micro-ORM) into an ASP.NET Core 3.1 WebAPI using Clean Architecture principles, the Repository Pattern, and Unit of Work. The tutorial covers setting up an MS-SQL database, structuring the project into Core, Application, and Infrastructure layers, implementing generic and product-specific repositories, registering services in the DI container, and testing CRUD endpoints via Swagger.
Table of contents
What is Dapper?Implementing Dapper in ASP.NET CoreCreating the MS-SQL Database and TableGetting Started with ASP.NET Core WebApi ProjectTesting with SwaggerSummary13 Impressions