Home  /  Questions  /  Question



50   50
Feb 26, 2014


Comparison of MicroORMs (SPARK)

Do you have a comparison of Spark, ADO.NET, Dapper.NET and Entity Framework?

Also can I switch to using Dapper.NET or nHibernate? Do I have the choice like I had in the earlier framework?  





508   99.9
Feb 27, 2014
Hi Vivek: 

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.





0   0
Aug 14, 2017
It is quite difficult to do comparison between the ORM frameworks as lot of ORMs are available now-a-days such as NHibernet, Dapper, Entity Framework, NJDX, etc. But I can suggest you one link that provides best ORM frameworks for major and most used platforms...Java, .Net, Android, etc.
Explore this link: http://www.softwaretree.com/