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
ZZZ Projects