advertisement

Dapper - Rise of the MicroORM

33 %
67 %
advertisement
Information about Dapper - Rise of the MicroORM
Technology

Published on March 14, 2014

Author: squarehire

Source: slideshare.net

Description

Presentation slides on Dapper, the best way to do persistence on .Net without destroying the maintainability of your app.
advertisement

Dapper Rise of the MicroORM Rudy Lacovara rudy@hireflo.com 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

DieselWorkers Architecture • Common – code needed across multiple layers • Core – contains both business logic and data access logic. Core is the only library that connects to a DB. • All application layer code, like the webapps and the processor, is built on top of Core. Common Web App (MVC 3) Core SqlServer Database MongoDB Document store Processor Single Page JavaScript App (Knockout.js)

Add a comment

Related presentations

Presentación que realice en el Evento Nacional de Gobierno Abierto, realizado los ...

In this presentation we will describe our experience developing with a highly dyna...

Presentation to the LITA Forum 7th November 2014 Albuquerque, NM

Un recorrido por los cambios que nos generará el wearabletech en el futuro

Um paralelo entre as novidades & mercado em Wearable Computing e Tecnologias Assis...

Microsoft finally joins the smartwatch and fitness tracker game by introducing the...

Related pages

The Rise of the MicroORM Tickets, Tue, 11 Oct 2011 at 18 ...

... 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.
Read more

The Rise of the Micro-ORM with Sam Saffron and Rob Conery ...

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 ...
Read more

.net - What are some of the benefits of a "Micro-ORM ...

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 ...
Read more

Hanselminutes Podcast 262 - The Rise of the Micro-ORM with ...

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 ...
Read more

MicroORM - A Dynamically Typed ORM for VB and C# in about ...

... InfoQ Homepage Articles MicroORM ... The Rise of the Micro-ORM with Sam Saffron and Rob Conery by Jonathan Allen Posted Source code... by ...
Read more

'micro-orm' tag wiki - Stack Overflow

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 ...
Read more

Frederic Torres Blog: The Rise of the Micro-ORM or How C# ...

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 ...
Read more

Small is Beautiful - .NET Micro ORMs | Dan 'Diplo' Booth

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 ...
Read more