A Comparative Study of the Features and Performance of ORM Tools in a .NET Environment
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.
KeywordsObject-relational mapping (ORM) persistence performance evaluation
Unable to display preview. Download preview PDF.
- 1.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)Google Scholar
- 2.Ambler, S.: Agile Database Techniques. Wiley, Chichester (2003)Google Scholar
- 3.Bauer, C., King, G.: Java Persistence with Hibernate. Manning Publications (2006)Google Scholar
- 4.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)Google Scholar
- 5.Keene, C.: Data Services for Next-Generation SOAs. SOA World Magazine (2004), http://soa.sys-con.com/node/47283
- 6.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
- 7.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)Google Scholar
- 8.Microsoft Download Center SQL Server, Samples and Sample Databases (2005), http://www.microsoft.com/downloads/details.aspx?familyid=e719ecf7-9f46-4312-af89-6ad8702e4e6e
- 9.OracleTopLink, http://www.oracle.com/technology/products/ias/toplink
- 10.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)Google Scholar
- 11.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)Google Scholar