When comparing Entity Framework to ADO.NET, why is dapper ORM so fast?

ado.net compare dapper entity-framework-6 performance

Question

Please explain why Dapper ORM executes quickly by contrasting it with Entity Framework and ADO.NET. I obtained the comparative data from the site dapper vs entity framework.

1
1
1/16/2018 9:52:54 AM

Popular Answer

Dapper never has a speed advantage over ADO.Net. Period!

Although we are aware that the Dapper team has created a way through IL to simply speed up the process, it is still operating on top of ADO.Net. They are only abstracting the ADO.Net and processed everything on top of it by converting the actual data (rows) back to the object models (POCO or DTO), and that would add additional time doing it.

Everyone, in my opinion, has to be aware of how the ADO.Net layer differs from other ORMs that are out there.

The Dapper team may be able to be much quicker if they create their own DbDataReader, but this won't happen until they do it.

Since Dapper is currently the lightest ORM available, there is little doubt that it is much quicker than EF.

IMHO

1
7/3/2018 8:39:02 AM


Related Questions





Related

Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow
Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow