Dapper ORM
Stable release | 1.10 / June 27, 2012 |
---|---|
Written in | C# |
Operating system | Cross-platform |
Platform | .NET3.5 or 4.0 and Mono |
Type | Object-relational mapping |
License | Apache License 2.0 or MIT License |
Website |
github |
Dapper is an object-relational mapping (ORM) product for the Microsoft .NET platform: it provides a framework for mapping an object-oriented domain model to a traditional relational database. Its purpose is to relieve the developer from a significant portion of relational data persistence-related programming tasks. Dapper is free as open source software that is distributed under dual license, either the Apache License 2.0 or the MIT License.
Feature summary
Dapper's primary feature is mapping from .NET classes to database tables (and from CLR data types to SQL data types). Dapper also provides data query and retrieval facilities.
Dapper is a micro-ORM: it does not offer the full range of features of a full ORM such as NHibernate or Entity Framework. This is by design. It focuses on simplicity and performance rather than full automation. Dapper does not generate the SQL queries, but only maps the result to Plain Old CLR Objects (POCOs). Third party extensions are available for mapping objects to INSERT and UPDATE queries. It is optimized for use with .NET 4.0 or higher.
The single class ORM is also available on NuGet.
History
Dapper was started by Sam Saffron and Marc Gravell because of the N+1 and other performance issues with Entity framework. It was written for and is used by Stack Overflow.<ref>http://meta.stackexchange.com/questions/104970/what-orm-does-stack-overflow-use-with-their-asp-net-mvc-project