Comparative Analysis of ORM Systems for the .NET Platform
Article Sidebar
Open full text
Issue Vol. 31 (2024)
-
Comparative analysis of the implementation performance using selected scripting languages in the Godot game engine
Sebastian Alchimowicz, Małgorzata Plechawska-Wójcik68-72
-
Comparative analysis of smart home management systems
Patryk Bąk, Grzegorz Kozieł73-81
-
Comparative analysis of database types in mobile applications running on the Android operating system
Adrian Bartoszek82-88
-
Comparative analysis of the performance of selected database management system
Piotr Marcin Tracz, Małgorzata Plechawska-Wójcik89-96
-
Comparative Analysis of ORM Systems for the .NET Platform
Tomasz Wiatrowski97-102
-
Analysis of Compliance with WCAG Guidelines Regarding Contrast Im-plementation in an E-Learning Quiz
Krzysztof Dziedzic, Marcin Barszcz, Tomasz Wiśniewski103-108
-
Comparative analysis of Microsoft’s ,,low-code” programming technology
Grzegorz Łopata, Konrad Gromaszek109-115
-
Efficiency comparison of message brokers
Sebastian Dyjach, Małgorzata Plechawska-Wójcik116-123
-
Investigating the impact of microservice-oriented platform configurations on application performance
Bartosz Biegajło, Dariusz Czerwiński124-131
-
Comparison of Laravel and Symfony - the most popular PHP frame-works, based on a simple CRUD application
Patryk Gajewski, Mariusz Dzieńkowski132-137
-
Analysis of the usability of selected auction websites
Adrian Duwer, Mariusz Dzieńkowski138-144
-
Comparison of selected tools for automation testing of Web applications
Piotr Pasławski, Maciej Pańczyk145-150
Main Article Content
DOI
Authors
tomasz.wiatrowski@pollub.edu.pl
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:
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].
Article Details
Abstract views: 518

