Dapper is a hybrid ORM. This is a great ORM for those who have a lot of ADO legacy code to convert. Dapper uses SQL queries and parameters can be used just like ADO, but the parameters to a query can be simplified into POCOs. Select queries in Dapper can also be translated into POCOs. Converting legacy code can be accomplished in steps because the initial pass of conversion from ADO is to add Dapper, followed by a step to add POCOs, then to change queries into LINQ (if desired). The speed difference in my tests show that Dapper is better than my implementation of ADO for select queries, but slower for inserts and updates. I would expect ADO to perform the best, but there is probably a performance penalty for using the data set adapter instead of the straight sqlCommand method.
If you’re interested in Dapper you can find information here: Stack Exchange/Dapper. Dapper has a NuGet package, which is the method I used for my sample program.
I rarely use ADO these days, with the exception of legacy code maintenance or if I need to perform some sort of bulk insert operation for a back-end system. Most of my projects are done in Entity Framework, using the .Net Core or the .Net version. This comparison doesn’t feel complete without including ADO, even though my smackdown series is about ORM comparisons. So I assembled a .Net console application with some ADO objects and ran a speed test with the same data as all the ORM tests.
NHiberate is the .Net version of Hibernate. This is an ORM that I used at a previous company that I worked for. At the time it was faster than Entity Framework 6 by a large amount. The .Net Core version of Entity Framework has fixed the performance issues of EF and it no longer makes sense to use NHibernate. I am providing the numbers in this test just for comparison purposes. NHibernate is still faster than ADO and Dapper for everything except the select. Both EF-7 and NHibernate are so close in performance that I would have to conclude that they are the same. The version of NHibernate used for this test is the latest version as of this post (version 4.1.1 with fluent 2.0.3).
Entity Framework 7 for .Net Core
I have updated the NuGet packages for .Net Core for this project and re-tested the code to make sure the performance has not changed over time. The last time I did a smackdown with EF .Net Core I was using .Net Core version 1.0.0, now I’m using .Net Core 1.1.1. There were not measurable changes in performance for EF .Net Core.
Here are the results side-by-side with the .ToList() method helper and without:
Test for Yourself!
First, you can download the .Net Core version by going to my GitHub account here and downloading the source. There is a SQL script file in the source that you can run against your local MS SQL server to setup a blank database with the correct tables. The NHibernate speed test code can also be downloaded from my GitHub account by clicking here. The ADO version is here. Finally, the Dapper code is here. You’ll want to open the code and change the database server name.