Awesome Dapper

Awesome

Dapper is a simple object mapper for .NET and own the title of King of Micro ORM in terms of speed and is virtually as fast as using a raw ADO.NET data reader.

A curated list of awesome dapper libraries, packages, and documentation.

Contributing

Please take a quick gander at the contribution guidelines first.

If you see a package here that is no longer maintained or is not a good fit, please submit a pull request to improve this file. Thank you!

Contents

Documentation and Learning

Supported Packages

  • Z.Dapper.Plus - Dapper Plus is a library that dramatically improves dapper performances by using high efficient Bulk Actions Helpers (Insert, Update, Delete, and Merge).
  • Dommel - Simple CRUD operations for Dapper.
  • Dapper.Contrib - The official collection to get, insert, update and delete helpers for Dapper.net.
  • Dapper-Async - Dapper-Async is a small library package which extends the IDbConnection interface with Async (asynchronous) methods.
  • Dapper.SimpleCRUD - Simple Get, GetList, GetListPaged, Insert, Update, Delete, DeleteList, and RecordCount extensions for Dapper.
  • 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.
  • Dapper.SqlBuilder - The Dapper SqlBuilder component, for building SQL queries dynamically.
  • LiteLib - A cool little wrapper for SQLite based on Dapper.
  • MicroOrm.Dapper.Repositories - CRUD for Dapper
  • MassTransit.DapperIntegration - MassTransit Dapper support; MassTransit is a message-based distributed application framework for .NET
  • Dapper.FluentMap - A small library which allows you to fluently map properties of your domain classes to the database columns.
  • Dapper.Rainbow - A small library which contains an abstract class that you can add to your project and use as a base class for your Dapper classes to provide CRUD operations, such as inserting, deleting, updating and getting records.
  • Dashing - Dashing is a simple to use mini ORM built on top of Dapper. It aims to provide fantastic productivity while not sacrificing (too much) performance.
  • Dapper.Database - Dapper.Database contains a number of helper methods for inserting, getting, updating and deleting records.
  • Dapper.ParameterExtensions - Extension on the Dynamic Parameters of Dapper to make life a little easier when passing parameters to Dapper executions.
  • Dapper.FastCrud.ModelGenerator - Entity generation for Dapper.FastCrud from a LocalDb or a MsSqlServer database.
  • Dapper.SimpleCRUD.ModelGenerator - You can autogenerate your POCOs directly from your database using this T4 Template.
  • Dapper.Abstractions - A simple abstraction atop the Dapper extension methods and TransactionScope for testability.
  • Dapper.FluentMap.Dommel - Dapper.FluentMap extension for Dommel support.
  • SQLinq.Dapper - Allows for SQLinq to be more easily used with a little help from "Dapper dot net".
  • Identity.Dapper - Identity package that uses Dapper instead EntityFramework for use with .NET Core.
  • TsSoft.Dapper.QueryBuilder - Library lets to build SQL queries for Dapper in a declarative manner by using criteria classes with attributes applied to their properties.
  • CatFactory.Dapper - CatFactory it's a scaffolding engine for .NET Core built in C#.
  • Dapper.Bulk - Dapper.Bulk contains helper methods for bulk inserting.
  • Dapper.MicroCRUD - CRUD Extensions for Dapper.Net
  • ZKWeb.ORM.Dapper - Support for Dapper in ZKWeb.
  • Dapper.Compose - Typed multi query composition for Dapper.

Unsupported Packages

  • DapperExtensions - DapperExtensions is a small library package which adds basic CRUD operations to Dapper.
  • Dapper.Mapper - A small library which extends Dapper multi-mapping functionality. It allows you to map a single row to multiple objects.
  • Dapper.SimpleSave - A small library package which adds basic CRUD operations to Dapper and saves complex objects to the database in a very simple way.
  • Dapper.Extension - CRUD extension methods for Dapper
  • Dapper.FluentColumnMapping - Fluent Object-Column Mappings for use with Dapper
  • Dapper.Fluent - Dapper.Fluent is a small and easy library that supports fluent API for query construction and execution over database connection using Dapper.Net.
  • Dapper.Tvp - A couple of helper classes to make using TVP parameters with Dapper easier.
  • Dapper.DynamicReportGenerator - A dynamic report generator for Dapper. Can be used to return generic data in CSV (currently) format.
  • Dapper.Extensions.Linq - Dapper.Extensions.Linq builds on this providing advanced DB access through Linq queries
  • Dapper.DataRepositories - Base classes to implement Repository pattern using Dapper as ORM
  • Dapper.Data - Micro-orm implemented on Dapper, streamlines connection and transaction management while preserving flexibility and usability of Dapper.
  • Dapper.SimpleLoad - Dapper.SimpleLoad simplifies Dapper multi-mapping to load complex objects from a relational database. It's the companion to Dapper.SimpleSave.
  • DeclarativeSql.Dapper - This library provides attribute-based table mapping and simple database access.
  • Stove.Dapper - Stove is an application framework that wraps and abstracts your needs for easy use. Built with strongly adopted dependency injection principles.
  • Dapper.TableValuedParameter - An extension to provide Table-Valued Parameters to Dapper. .NET Core support available!
  • Dapper.Extensions.Repository - Dapper.Extensions.Repository is an extension to integration with dapper-dot-net and MicroOrm.Dapper.Repositories.
  • Dapper.ColumnMapper - Simple extension to Dapper to allow an arbitrary column to property mapping
  • DapperWrappe - DapperWrapper is a library that wraps the Dapper extension methods on IDbConnection to make unit testing easier.
  • Storm.Dapper - Sql executor for Storm using Sam Saffron's Dapper.
  • Dapper.MoqTests - Assembly that assists in testing Dapper methods, allows for Verify and Setup with SQL and parameters
  • Dashing.Testing - Dashing is a simple to use mini ORM built on top of Dapper. It aims to provide fantastic productivity while not sacrificing (too much) performance.

Providers

  • Dapper.Rainbow.MySql - Implementation of Dapper.Rainbow targeting MySql, with addons that gives you basic crud operations while having to write even less SQL.
  • Dapper.Rainbow.SQLite - Trivial micro-orm implemented on Dapper, provides with CRUD helpers. specialize to handle SQLite
  • Dapper.Oracle - Dapper support for Oracle providers
  • Dapper.Rainbow.PostgreSql - Trivial micro-orm implemented on Dapper, provides with CRUD helpers.