Dapper Extensions is a small NuGet library that extends the IDbConnection for Dapper by adding basic CRUD operations (Get, Insert, Update, Delete) for your domain classes.
The following is the list of extension methods that are provided in Dapper Extensions.
| Method | Description |
|---|---|
| Get | Retrieve a record based on the primary key. |
| GetList | Retrieve a list of records from a table. |
| Insert | Inserts a row into the database. |
| Update | Update a record in the database. |
| Delete | Delete a record based on primary key |
| Count | Counts all the records in a table or a range of records if a conditional clause was set up in the statement options. |
You can easily install it from the Package Manager Console window by running the following command.
PM> Install-Package DapperExtensions
Get, Insert, Update, and Delete operations.GetList and Count methods.GetPage method for returning paged result sets.ClassMapper.