Dapper.FastCrud is a small NuGet library that extends the IDbConnection for Dapper and is based on C# 6 and VB 14 essential features that have finally raised the simplicity of raw SQL constructs to acceptable maintenance levels.
The following is the list of extension methods that are provided in Dapper.FastCrud.
| Method | Description |
|---|---|
| Get | Retrieve a record based on the primary key. |
| Find | Retrieve a list of records from a table. |
| Insert | Inserts a row into the database. |
| Update | Update a record in the database. |
| BulkUpdate | Updates a list of records in the database. |
| Delete | Delete a record based on primary key |
| BulkDelete | Deletes all the records in the table or a range of records if a conditional clause was set up in the statement options. |
| Count | Counts all the records in a table or a range of records if a conditional clause was set up in the statement options. |
For projects targeting .NET 4.5 or later, you can also use the async versions of all the above methods.
You can easily install it from the Package Manager Console window by running the following command.
PM> Install-Package Dapper.FastCrud
Dapper.FastCrud.ModelGenerator.