Dapper: Simple object mapper for .NET
Lightweight ORM extending ADO.NET with simple query methods for .NET applications.
Learn more about Dapper
Dapper is a micro-ORM library that provides extension methods for ADO.NET DbConnection instances to simplify database operations. It works by extending existing database connections with methods like Query<T>(), Execute(), and QuerySingle<T>() that automatically map SQL results to .NET objects. The library uses reflection and compiled expressions to achieve efficient object mapping while maintaining a minimal footprint. It supports both synchronous and asynchronous operations, parameterized queries, and can map to POCOs, dynamic objects, or primitive types.
Minimal Overhead
Functions as extension methods on existing ADO.NET connections without requiring configuration or complex setup. Maintains close-to-raw ADO.NET performance while adding object mapping convenience.
Flexible Mapping
Maps query results to strongly-typed objects, dynamic types, or primitive values. Supports anonymous types and Dictionary objects for parameter binding.
SQL Control
Requires explicit SQL queries rather than generating them automatically. Provides direct control over database operations while handling parameter binding and result mapping.
TFM updates, async API normalization, and DateOnly/TimeOnly support disabled due to failure modes.
- –TFM update; +net8 (LTS), -net5, -net7
- –normalize async API surface over all TFMs
- –disable DateOnly / TimeOnly support
- –change dapper-plus citation
- –Do not close the inner reader when disposing wrapped data readers
Fixes NuGet readme.
- –fixes NuGet readme
Reverts previous change and adds new sponsor.
- –revert previous change - see issue for more details
- –new sponsor: Dapper Plus
Top in Backend & APIs
Related Repositories
Discover similar tools and frameworks used by developers
PHPMailer
SMTP client and MIME message builder for PHP.
Express
Middleware-based HTTP routing and response handling for Node.js.
Spring Framework
Comprehensive framework for building enterprise Java applications with infrastructure support.
Celery
Asynchronous task queue with distributed worker execution.
Magento 2
Modular PHP platform for self-hosted ecommerce storefronts.