Abstract
Object-relational mapping is a technology that connects relationships with object-oriented entities, which aims to eliminate duplicate layers together with costs of maintenance and any errors arising from their existence. A lot of tools and technologies were designed in order to support and implement idea of object-relational mapping. In this paper we present the performance comparison of two most common object-relational mapping interfaces for .NET framework: Entity Framework and NHibernate. In the .NET developers community, there is a lot of discussion today about the similarities and differences of the both technologies. To address this issue, we compared the features and performance of both tools. We analysed the performance of Entity Framework and NHibernate for two different databases (MS SQL Server and PostgreSQL), different query languages (lambda expressions and LINQ for Entity Framework and HQL and Critera API for NHibernate) and compared the results with the standard SqlClient queries. The results show that there is no significant difference between these both tools and we proved that common opinion that NHibernate performs better than Entity Framework is incorrect.
This is a preview of subscription content, log in via an institution to check access.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Preview
Unable to display preview. Download preview PDF.
Similar content being viewed by others
References
NHibernate 3.3.1 (2013), http://nhforge.org/
Barnes, J.: Object-Relational Mapping as a Persistence Mechanism for Object-Oriented Applications. Master’s thesis, Macalester College, Saint Paul, Minnesota, USA (2007)
Bhatti, S., Abro, Z., Rufabro, F.: Performance evaluation of java based object relational mapping tool. Mehran University Research Journal of Engineering and Technology 32(2), 159–166 (2013)
Cvetković, S., Janković, D.: A comparative study of the features and performance of ORM tools in a .NET environment. In: Dearle, A., Zicari, R.V. (eds.) ICOODB 2010. LNCS, vol. 6348, pp. 147–158. Springer, Heidelberg (2010)
Doomen, D.: Entity framework 5/6 vs nhibernate 3 – the state of affairs (2013), http://www.dennisdoomen.net/2013/03/entity-framework-56-vs-nhibernate-3.html (accessed December 2013)
Entity Framework team: Entity framework 5.0 (2013), http://entityframework.codeplex.com/
Fowler, M.: Ormhate (2013), http://martinfowler.com/bliki/OrmHate.html (accessed December 2013)
Marguerie, F.: Choosing an object-relational mapping tool, http://madgeek.com/Articles/ORMapping/EN/mapping.htm (accessed December 2013)
Microsoft Corporation: Microsoft SQL server 2012 (2013), http://www.microsoft.com/en-us/sqlserver/
Płuciennik-Psota, E.: Object relational interfaces survey. Studia Informatica 33(2A), 299–310 (2012)
The PostgreSQL Global Development Group: PostgreSQL 9.3.2 (2013), http://www.postgresql.org
Author information
Authors and Affiliations
Corresponding author
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2014 Springer International Publishing Switzerland
About this paper
Cite this paper
Gruca, A., Podsiadło, P. (2014). Performance Analysis of .NET Based Object–Relational Mapping Frameworks. In: Kozielski, S., Mrozek, D., Kasprowski, P., Małysiak-Mrozek, B., Kostrzewa, D. (eds) Beyond Databases, Architectures, and Structures. BDAS 2014. Communications in Computer and Information Science, vol 424. Springer, Cham. https://doi.org/10.1007/978-3-319-06932-6_5
Download citation
DOI: https://doi.org/10.1007/978-3-319-06932-6_5
Publisher Name: Springer, Cham
Print ISBN: 978-3-319-06931-9
Online ISBN: 978-3-319-06932-6
eBook Packages: Computer ScienceComputer Science (R0)