Dapper ORM Tutorial: Streamlining Data Access in C# .NET MVC
This tutorial explores Dapper, a high-performance micro-ORM for .NET, and its key advantages for simplifying database interactions. We'll cover Dapper installation within a C# .NET MVC project and demonstrate how it reduces boilerplate ADO.NET code, enabling efficient mapping of SQL query results to C# objects. Learn how Dapper enhances performance and simplifies data access logic.
Chapters (Timestamps)
00:00 - What is Dapper
01:05 - Features of Dapper
02:15 - Explaining code without Dapper
03:23 - Code with Dapper
03:49 - Explaining database setup in SSMS
04:23 - Creating an MVC project in Visual Studio
05:20 - Adding database connection string
05:38 - Setting up C# MVC Project
06:43 - Adding MVC razor view to show list of products
07:25 - Writing ADO.NET code to fetch data
10:23 - Installing Dapper NuGet package
10:57 - Replacing ADO.NET code with Dapper implementation
12:03 - Outro