Last post Mar 01, 2021 07:22 PM by Mikesdotnetting
Mar 01, 2021 07:20 AM|dotNETaspirant|LINK
Hello. Anyone done any benchmarking recently, is EF Core STILL
slower than ADO.NET and DAPPER like the analysis done in this article ?
Dapper vs Entity Framework vs ADO.NET Performance Benchmarking (exceptionnotfound.net)
Mar 01, 2021 08:20 AM|Mikesdotnetting|LINK
The code for the performance test is included in the article. So you can always use it to run your own tests to answer your question.
One thing I would say is that the ADO.NET test uses a DataTable. That is a lot slower than ADO.NET using a DataReader (which is basically what Dapper does). Even then, you could probably speed up the ADO.NET test by specifying the DataTable columns and datatypes
explicitly rather than leaving it to ADO.NET to figure out.
But the answer to your question is Yes, Dapper is quicker than EF Core for reading data. And it probably always will be, because it is not a full blown ORM like EF Core. It is a simple object mapper and designed specifically to be quicker than EF Core for
Mar 01, 2021 05:13 PM|DA924|LINK
Myself as far as speed needed in some situations, I would just go with ADO.NET, SQL Command Objects, T-SQL and custom objects. I don't see the need to introduce Dapper into the mix and using EF.
Mar 01, 2021 07:22 PM|Mikesdotnetting|LINK
I don't see the need to introduce Dapper into the mix