THE SQL Server Blog Spot on the Web

Welcome to - The SQL Server blog spot on the web Sign in | |
in Search

Davide Mauri

A place for my thoughts and experiences the Microsoft Data Platform

Speaking @ PASS Summit 2017

After years and years talking about Business Intelligence and Business Analytics, this year at PASS I’ll be speaking about Application Development and how to make the best use of the data platform that Microsoft created so far.

I’ve started talking about the impedance mismatch at the beginning of my career and now, after 15 year of Business Intelligence, Big Data, Analytics, Data Warehousing, I’m back talking about it again, but this time there is a new amazing approach to the problem: microORM.

MicroORM are ORM that only take care of one thing: mapping database result-set to classes and nothing more. I love the idea because it allows developers and DBAs to leverage all the power of RDBMS whilst, at the same time, remove all the boring and error-prone plumbing code. As Van Halen said, it is just the “Best of Both Worlds”.

As a result, MicroORM are, in my opinion, just perfect in a Micro-Services scenario. They make things simple, but not simpler, while preserving performance and making a developer just more productive (give that he/she must know how to query a database, something that is mandatory IMHO).

More specifically I’ll talking about Dapper.NET a microORM I’ve learned to love in the last years, and that I use everyday:

Dapper: the microORM that will change your life

ORM or Stored Procedures? Code First or Database First? Ad-Hoc Queries? Impedance Mismatch? If you're a developer or you are a DBA working with developers you have heard all this terms at least once in your life…and usually in the middle of a strong discussion, debating about one or the other. Well, thanks to StackOverflow's Dapper, all these fights are finished. Dapper is a blazing fast microORM that allows developers to map SQL queries to classes automatically, leaving (and encouraging) the usage of stored procedures, parameterized statements and all the good stuff that SQL Server offers (JSON and TVP are supported too!) In this session I'll show how to use Dapper in your projects from the very basis to some more complex usages that will help you to create *really fast* applications without the burden of huge and complex ORMs. The days of Impedance Mismatch are finally over!

See you at PASS 2017!

Published Monday, July 24, 2017 10:34 AM by Davide Mauri

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS



Brent Ozar said:

That's awesome! I'm looking forward to this one. Congratulations!

July 24, 2017 7:00 AM

Jon said:

Another micro orm you might like, FSharp.Data.SqlClient. It takes the work out of Dapper and makes it so you can know if something changes in your database automatically. Of course, you need to be using F# to take advantage of this amazing technology.

I've built a class generator for Dapper so, it gives me similar benefits of the FSharp.Data.SqlClient library but is more manual. If you are interested I can share the link with you, I haven't posted it yet, but my boss said he didn't care if I shared it. It needs some work, but it works for my limited use case.

July 24, 2017 9:22 AM

Davide said:

Thanks Brent, see you there :)

July 25, 2017 4:17 AM

Davide said:

Thanks Jon, that sounds interesting, I'll definitely take a look at it. Thanks!

July 25, 2017 4:18 AM

Fabian Pascal said:

Oh, no, not the impedance mismatch again.

July 26, 2017 2:21 PM

abx said:


May 31, 2018 10:58 PM

dongdong8 said:



June 29, 2018 3:31 AM

linying123 said:



July 16, 2018 8:55 PM

yaoxuemei said:


August 15, 2018 2:04 AM

qqq said:

August 16, 2018 12:15 AM

chenjinyan said:



August 22, 2018 11:09 PM

shenyuhang said:


August 23, 2018 10:19 PM

kakakaoo said:

October 8, 2018 2:24 AM

chenjinyan said:



October 9, 2018 6:48 PM

chenqiuying said:


October 10, 2018 6:20 PM

kakakaoo said:


November 8, 2018 2:07 AM

Leave a Comment


About Davide Mauri

Director of Software Development & Cloud Infrastructure @ Sensoria, an innovative smart garments and wearable company. After more than 15 year playing with the Microsoft Data Platform, with a specific focus on High Performance databases, Business Intelligence, Data Science and Data Architectures, he's now applying all his skills to IoT, defining architectures to crunch numbers, create nice user experiences and provide meaningful insights, all leveraging Microsoft Azure cloud. MVP on Data Platform since 2006 he has a very strong background development and love both the ER model and OO principles. He is also a fan of Agile Methodology and Automation, which he tries to apply everywhere he can, to make sure that "people think, machines do".

This Blog


Privacy Statement