Comparative analysis of selected object-relational mapping systems for the .NET platform


Abstract

This article is devoted to the comparison of two object-relational mapping systems supported by .NET platform - Entity Framework Core and NHibernate. The research hypothesis “framework NHibernate is more efficient than Entity Framework Core in the context of DML operations” was put forward. In order to make an efficiency analysis of ORM frameworks, a desktop application was designed and implemented to enable testing and visualization of results. The NHibernate framework turned out to be much more efficient than Entity Framework Core in single tests and slightly faster in bulk tests. The stability of both frameworks was similar.


Keywords

.NET; ORM; Entity Framework Core; NHibernate

Object-relational mapping, https://en.wikipedia.org/wiki/Object-relational_mapping, [16.06.2020]

Borys P., Pańczyk B.: Wydajność pracy z bazami danych w aplikacjach ASP.NET MVC. Journal of Computer Science Institute 6, 2018.

Zmaranda D., Pop-Fele L-L., Győrödi C., Győrödi R., Pecherle Performance Comparison of CRUD Methodsusing NET Object Relational Mappers: A Case Study (IJACSA) International Journal of Advanced Computer Science and Applications,Vol. 11, No.1, 2020.

Wiphusitphunpol W., Letrusdachakul T.: Fetch performance comparison of object relational mapper in .NET platform. [W]: 14th International Conference on Electrical Engineering/Electronics, IEEE, Computer, Telecommunications and Information Technology (ECTI-CON), Phuket, Tajlandia 7 listopada 2017 r.

Cvetković S., Janković D.: A Comparative Study of the Features and Performance of ORM Tools in a .NET Environment. [W]: Objects and Databases ICOODB 2010. Lecture Notes in Computer Science, vol 6348. Springer, Berlin, Heidelberg. Frankfurt, Niemcy. 28-30 września 2010 r.

Gruca A., Podsiadło P.: Performance Analysis of .NET Based Object–Relational Mapping Frameworks. [W]: Beyond Databases, Architectures, and Structures. BDAS 2014. Communications in Computer and Information Science, vol 424. Springer, Cham. Ustroń Polska, 27-30 maja 2014 r.

Dokumentacja szkieletu programistycznego Entity Framework Core, https://docs.microsoft.com/en-us/ef/core/, [22.04.2020].

Dokumentacja szkieletu programistycznego NHibernate, https://nhibernate.info/, [29.03.2020].

Dokumentacja biblioteki FluentNHibernate https://github.com/FluentNHibernate/fluent-nhibernate/wiki, [10.05.2020].

Entity Framework Core Tutorial, https://www.entityframeworktutorial.net/efcore/entity-framework-core.aspx, [25.04.2020].

Download

Published : 2020-09-30


Drzazga, K., Bobel, M., & Skublewska-Paszkowska, M. (2020). Comparative analysis of selected object-relational mapping systems for the .NET platform. Journal of Computer Sciences Institute, 16, 285-292. https://doi.org/10.35784/jcsi.2024

Krzysztof Drzazga  krzysztof.drzazga@pollub.edu.pl
Marcin Bobel 
Maria Skublewska-Paszkowska