Abstract
Object Relational Mapping (ORM) tools are increasingly becoming important in the process of information systems development, but still their level of use is lower than expected, considering all the benefits they offer. In this paper, we have presented comparative analysis of the two most used ORM tools in .NET programming environment. The features, usage and performance of Microsoft Entity Framework and NHibernate were analyzed and compared from a software development point of view. Various query mechanisms were described and tested against conventional SQL query approach as a benchmark. The results of our experiments have shown that the widely accepted opinion that ORM introduces translation overhead to all persistence operations is not correct in the case of modern ORM tools in .NET environment. Therefore, at the end of this paper we have discussed some reasons for insufficiently widespread application of ORM technology.
This is a preview of subscription content, log in via an institution.
Buying options
Tax calculation will be finalised at checkout
Purchases are for personal use only
Learn about institutional subscriptionsPreview
Unable to display preview. Download preview PDF.
References
Adya, A., Blakeley, J., Melnik, S., Muralidhar, S.: Anatomy of the ADO.NET Entity Framework. In: ACM SIGMOD International Conference on Management of Data, Beijing, China, pp. 877–888 (2007)
Ambler, S.: Agile Database Techniques. Wiley, Chichester (2003)
Bauer, C., King, G.: Java Persistence with Hibernate. Manning Publications (2006)
Castro, P., Melnik, S., Adya, A.: ADO.NET entity framework: raising the level of abstraction in data programming. In: ACM SIGMOD International Conference on Management of Data, Beijing, China, pp. 1070–1072 (2007)
Keene, C.: Data Services for Next-Generation SOAs. SOA World Magazine (2004), http://soa.sys-con.com/node/47283
Kopteff, M.: The Usage and Performance of Object Databases compared with ORM tools in a Java environment. In: 1st International Conference on Objects and Databases (ICOODB 2008), Berlin, Germany (2008), http://soa.sys-con.com/node/47283
Meijer, E., Beckman, B., Bierman, G.M.: LINQ: Reconciling Objects, Relations and XML in the.NET Framework. In: ACM SIGMOD International Conference on Management of Data, Chicago, IL, USA, pp. 706–706 (2006)
Microsoft Download Center SQL Server, Samples and Sample Databases (2005), http://www.microsoft.com/downloads/details.aspx?familyid=e719ecf7-9f46-4312-af89-6ad8702e4e6e
OracleTopLink, http://www.oracle.com/technology/products/ias/toplink
Van Zyl, P., Kourie, D.G., Boake, A.: Comparing the performance of object databases and ORM tools. In: Bishop, J., Kourier, D. (eds.) Annual research conference of the South African institute of computer scientists and information technologists on IT research in developing countries (SAICSIT 2006), Somerset West, South Africa, pp. 1–11 (2006)
Zhang, W., Ritter, N.: The Real Benefits of Object-Relational DB-Technology for Object-Oriented Software Development. In: 18th British National Conference on Databases: Advances in Databases, Chilton, UK, pp. 89–104 (2001)
Author information
Authors and Affiliations
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2010 Springer-Verlag Berlin Heidelberg
About this paper
Cite this paper
Cvetković, S., Janković, D. (2010). A Comparative Study of the Features and Performance of ORM Tools in a .NET Environment. In: Dearle, A., Zicari, R.V. (eds) Objects and Databases. ICOODB 2010. Lecture Notes in Computer Science, vol 6348. Springer, Berlin, Heidelberg. https://doi.org/10.1007/978-3-642-16092-9_14
Download citation
DOI: https://doi.org/10.1007/978-3-642-16092-9_14
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-642-16091-2
Online ISBN: 978-3-642-16092-9
eBook Packages: Computer ScienceComputer Science (R0)