Comparative Analysis of ORM Systems for the .NET Platform
Tomasz Wiatrowski
tomasz.wiatrowski@pollub.edu.plDepartment of Computer Science, Lublin University of Technology (Poland)
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 DBReferences
Object-relational mapping, https://en.wikipedia.org/wiki/Object-relational_mapping, [18.11.2023].
Google Scholar
Entity Framework Core, https://learn.microsoft.com/en-us/ef/core, [18.11.2023].
Google Scholar
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.
Google Scholar
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.
Google Scholar
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.
Google Scholar
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.
Google Scholar
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.
Google Scholar
Dapper, https://github.com/DapperLib/Dapper, [18.11.2023].
Google Scholar
LINQ to DB, https://linq2db.github.io, [18.11.2023].
Google Scholar
Bogus, https://github.com/bchavez/Bogus, [22.11.2023].
Google Scholar
BenchmarkDotNet, https://github.com/dotnet/BenchmarkDotNet, [22.11.2023].
Google Scholar
Authors
Tomasz Wiatrowskitomasz.wiatrowski@pollub.edu.pl
Department of Computer Science, Lublin University of Technology Poland
Statistics
Abstract views: 159PDF downloads: 167
