Sunday, January 29, 2012

MicroORM performance investigations

Hi All.

I would like to share some investigations on few MicroORM performance.
These investigations are inspired mostly by dapper-dot-net extensive performance.
I was choosing a fast ORM for my load-critical application. Dapper's select extreme performance was demonstrated. But what about inserts? Dapper do not explicitly support inserts, you can write a SQL query by yourself, but with the risk of getting column name or parameter wrong. After some browsing I found Dapper-Extensions and PetaPoco that seem to have an ability to insert/update an entity without specifying all columns explicitly. I also wanted to know what Entity Framework 4.2 performance is.