Basic CRUD operation using Dapper!

Dapper is an object mapper for .Net. As per stackoverflow definition, dapper is a micro-ORM, offering core parameterization and materialization services, but (by design) not the full breadth of services that you might expect in a full ORM such as LINQ-to-SQL or Entity Framework.

While working on one project in my company, I have come across this library and found that it is one of the fastest ORMs available in .net. For statistics, below is the result of select mapping over 500 iterations using different methods.

You can check more performance results of dapper at this GitHub link.

Let’s create a sample CRUD operation project with dapper as an ORM using ASP.NET MVC 4 and SQL Server.

You can add a dapper library to your project by downloading it from google code, or by using NuGet packages as shown below image.

I have created a class named person as shown below.

Also created database as shown below:

Below is the basic CRUD operations mapping with dapper.

1. Select operation

2. Directly executing SQL statement

3. Using stored procedures and pass argument

4. Using dynamic parameters to pass arguments

5. Returning output parameter from the stored procedure

I hope, this article is helpful to you in getting started with Dapper.

   

About the Author

ByteScout Team of Writers ByteScout has a team of professional writers proficient in different technical topics. We select the best writers to cover interesting and trending topics for our readers. We love developers and we hope our articles help you learn about programming and programmers.