Feb 27, 2014
It is very hard to quantify the performance differences of these technologies. There are very many factors that affect the numbers, such as: complexity of the data model, the formulation and complexity of the SQL,the table sizes, requirements and complexity of the application, etc.
In fact, we talk about this in the documentation. What I can tell you is that the differences between MicroORMs (SPARK) and Entity Framework is very significant. Entity Framework has many internal layers, whereas MicroORM is 'close to the metal' by creating SQL that is sent directly to the database. Another advantage is that the SQL is 'right in your face' (without actually writing SQL) so, there are no questions as to what actually gets executed on the database.
Patterns in Action supports different ORMs (Entity Framework, ADO.NET), but SPARK is highly optimized for performance (and ease of use) and therefore is not coded to be swapped out with other technologies like Dapper and nHibernate.
Hope this answers your questions.