Third Party Library - Dapper.FastCrud



Dapper.FastCrud is an extension 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.

It is recommended to use Visual Studio 2015 or an equivalent build environment when using features like string interpolation.


Dapper.FastCrud is available through NuGet:

You can easily install this library by running the following command:

PM> Install-Package Dapper.FastCrud


  • This library package contains both .NET 4.5 and 4.6 DLLs, and one of them will be installed only based on the target framework selected in your project.
  • Dapper.FastCrud can support SQLSever, LocalDB, SQLite, MySQL and PostgreSQL etc.
  • Composite primary keys mapping.
  • Multiple entity mappings are supported
  • Methods are available for CRUD operations.
  • A simple SQL builder with alias support is provided, which can be used when manual SQL queries are unavoidable.
  • Entity generation support is also provided by installing the NuGet package, Dapper.FastCrud.ModelGenerator.


Once you installed this library then the following extension methods will automatically add to DbConnection:

  • Get
  • Find
  • Insert
  • Update
  • BulkUpdate
  • Delete
  • BulkDelete
  • Count

There is no configuration required and no need for extra coding. You can easily use these extension methods in your code.

var invoice = connection.Get(new Invoice { Id = 1 });
var list = connection.Find<Invoice>();

connection.Insert<Invoice>(new Invoice { Kind = InvoiceKind.WebInvoice, Code = "Insert_Single_1" });

invoice.Code = "Updated_invoice";
invoice.Kind = InvoiceKind.WebInvoice;

var status = connection.Update<Invoice>(invoice);

var isDeleted = connection.Delete<Invoice>(new Invoice { Id = 2 });

var count = connection.Count<Invoice>();

You can find the detailed documentation here:


This library is supported on a regular basis and you will get your answers within next few days.