Dapper ORM

This article is about the .NET library. For other uses, see Dapper.
Dapper
Stable release 1.10 / June 27, 2012 (2012-06-27)
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.com/StackExchange/dapper-dot-net

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

See also

References

    External links

    This article is issued from Wikipedia - version of the Thursday, February 11, 2016. The text is available under the Creative Commons Attribution/Share Alike but additional terms may apply for the media files.