Published on March 14, 2014
Dapper Rise of the MicroORM Rudy Lacovara firstname.lastname@example.org http://rlacovara.blogspot.com
What is Dapper? It’s a data access technology written by these guys Sam Saffron http://samsaffron.com Marc Gravell http://marcgravell.blogspot.com/
What is Dapper? To make this go faster:
Dapper is a simple data mapper 1. You write a query string myQuery= “SELECT * FROM AppUser” 2. You pick a return class AppUser 3. You get an open IDbConnection var con = (new SqlConnection()).Open() 4. Dapper executes your query and maps the results to an IEnumerable<T> var users = con.Query<AppUser>(query)
The Dapper Philosophy • Embrace TSQL • Run it really fast • Keep It Simple Stupid Dapper is a single file that contains extension methods for IDBConnection • Convention over Configuration map returned data to DTOs by matching field names to property names
Performance Performance of SELECT mapping over 500 iterations - POCO serialization Method Duration Hand coded (using a SqlDataReader) 47ms Dapper ExecuteMapperQuery<Post> 49ms ServiceStack.OrmLite(QueryById) 50ms PetaPoco 52ms BLToolkit 80ms SubSonic 107ms NHibernate SQL 104ms Linq 2 SQL ExecuteQuery 181ms Entity framework ExecuteStoreQuery 631ms Performance stats taken from http://code.google.com/p/dapper-dot-net
... Midlands Developer Network presents The Rise of the MicroORM ... , Dapper.Net and Simple.Data and see if they can help reduce your data access pain.
The Rise of the Micro-ORM with Sam Saffron and ... Scott's at Mix this week and he sits down with Sam Saffron and Rob Conery to talk ... Dapper by Sam ...
The best answers are voted up and rise to the top What are some of the benefits of a “Micro-ORM”? up vote 19 down vote ... Like Dapper, it's fast ...
Scott's at Mix this week and he sits down with Sam Saffron and Rob Conery to talk about their ... Dapper var guid = Guid ... I Like your show and the rise ...
... InfoQ Homepage Articles MicroORM ... The Rise of the Micro-ORM with Sam Saffron and Rob Conery by Jonathan Allen Posted Source code... by ...
Tag Info. info newest frequent ... There are some useful extensions to Dapper to do the simple crud ... Rob Conery and Sam Saffron discuss The Rise of ...
It starts with Hanselminute episode the Rise of the Micro-ORM with Sam Saffron and Rob Conery. Sam Saffron wrote the micro-ORM Dapper and Rob ...
Here I look into the rise of "micro" ORMs for .NET and C#. ... Dapper came about because Sam, a brilliant developer who works on the ...