Dapper Tutorial Dapper - Third-Party Libraries

In this article will get a quick overview of all the most popular third-party libraries that you can use with Dapper.

Why should you use a Third Party Library?

Dapper is a King of Micro ORM in terms of performance when querying data, but a lot of essential features/helpers are missing for some application scenarios.

Let's say, for example, you want to quickly updates thousands of entities at once. You can sure create your SQL and logic, but you can also use a library that has been exactly built for this (Dapper Plus), which also contains hundreds of options to customize your update statement the way you want.

Using a third-party library has several benefits, including the following:

  • You save development time (using code already done instead of doing it)
  • The code is robust (often used already by thousands of developers)
  • The code has previously been thoroughly tested. The library owner does the maintenance (if still supported!)

However, there are some downsides as well:

  • Your code depends on the library
  • If you have a bug or need help, you will not always have the support you want

There are many more advantages/disadvantages but using a third-party library or not is a lot of personal choice. Some developers prefer to control their code, while others prefer to keep their code simple and simply use tools built for their requirements.

Third-Party Library Overview

Here is a list of libraries that you can use with Dapper:

Library Type Support Documentation Features
Dapper Plus PRO < 1 Day Yes Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge
Bulk Action Async
Bulk Also Action
Bulk Then Action
Dapper Transaction Free < 1 Day Yes IDbTransaction extension methods for Dapper: A high performance Micro-ORM supporting SQL Server, MySQL, SQLite, SqlCE, Firebird etc..
Dapper.Contrib Free 2 - 3 Days Yes Get
GetAll
Insert
Update
Delete
DeleteAll
DapperExtensions Free No No Get
GetList
Insert
Update
Delete
Count
Dapper.FastCrud Free < 1 Day Yes Get
Find
Insert
Update
BulkUpdate
Delete
BulkDelete
Count
Dapper.FluentMap Free 2 - 5 Days Yes Manual mapping
Convention based mapping
Dapper.Mapper Free No No Multi-mapping
Dapper.Rainbow Free 2 - 3 Days No Get
Insert
Update
Delete
All
Dapper.SimpleCRUD Free 1 - 3 Days Yes Get
GetList
GetListPaged
Insert
Update
Delete
DeleteList
RecordCount
Dapper.SimpleSave Free No Yes Create
CreateAll
Update
UpdateAll
Delete
DeleteAll
SoftDelete
SoftDeleteAll