Dapper An Overview of 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.

You can also find more library on the Awesome Dapper List

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, MariaDB, 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

Related Articles

• Awesome Dapper List