Comparative Analysis of ORM Systems for the .NET Platform

Tomasz Wiatrowski

doi:10.35784/jcsi.6012

Open full text

PDF

Published: Jun 30, 2024

DOI: https://doi.org/10.35784/jcsi.6012

DOI

https://doi.org/10.35784/jcsi.6012

Authors

Tomasz Wiatrowski

tomasz.wiatrowski@pollub.edu.pl

Department of Computer Science, Lublin University of Technology

Abstract

This article presents a comparative study of three popular ORM (Object-Relational Mapping) systems used in the .NET technology: Entity Framework Core, Dapper, and LINQ to DB. The analysis is divided into two main parts: theoretical, focusing on research found in literature, and practical, where an application was implemented to assess the performance of each system and their memory consumption. The results obtained were presented in the form of graphs. Dapper emerged as the most efficient system and consumed the least memory in the majority of test cases.

Keywords:

ORM, Entity Framework Core, Dapper, LINQ to DB

References

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

Entity Framework Core, https://learn.microsoft.com/en-us/ef/core, [18.11.2023].

A. Ullah, M. Usman, M. Abrar, F. Ullah, N. Shah, M. F. Nadeem, Systematic performance and Security evaluation of .NET models for accessing database, VFAST Transactions on Software Engineering 9(4) (2021) 18-24. DOI: https://doi.org/10.21015/vtse.v9i4.752

A Güvercin, B. Avenoglu, Performance Analysis of Object-Relational Mapping (ORM) Tools in .NET 6 Environment, Bilişim Teknolojileri Dergisi 15(4) (2022) 453-465. DOI: https://doi.org/10.17671/gazibtd.1059516

D. Zmaranda, L. Pop-Fele, C. Gyorödi, R. Gyorödi, G. Pecherle, Performance comparison of crud methods using .NET object relational mappers: A case study, International Journal of Advanced Computer Science and Applications 11(1) (2020) 55-65. DOI: https://doi.org/10.14569/IJACSA.2020.0110107

W. Wiphusitphunpol, T. Lertrusdachakul, Fetch Performance Comparison of Object Relational Mapper in .NET Platform, In 2017 14th International Conference on Electrical Engineering/Electronics, Computer, Telecommunications and Information Technology (ECTI-CON) IEEE Xplore (2017) 423-426. DOI: https://doi.org/10.1109/ECTICon.2017.8096264

I. Basheleishvili, A. Bardavelidze, K. Bardavelidze, Study and Analysis of the .Net Platform-based Technologies for Working with the Databases, In Proceedings of the 33rd International Conference on Information Technologies InfoTech (2019) 1-8.

Dapper, https://github.com/DapperLib/Dapper, [18.11.2023].

LINQ to DB, https://linq2db.github.io, [18.11.2023].

Bogus, https://github.com/bchavez/Bogus, [22.11.2023].

BenchmarkDotNet, https://github.com/dotnet/BenchmarkDotNet, [22.11.2023].

Wiatrowski, T. (2024). Comparative Analysis of ORM Systems for the .NET Platform. Journal of Computer Sciences Institute, 31, 97–102. https://doi.org/10.35784/jcsi.6012

Article Sidebar

Main Article Content

DOI

Authors

Abstract

Keywords:

References

Article Details

License