Comparative analysis of database mapping frameworks available in NuGet Manager
Article Sidebar
Open full text
Issue Vol. 32 (2024)
-
Performance analysis of selected database management systems
Radosław Kowalczyk, Jakub Smołka151-156
-
Performance evaluation of designated containerization and virtualization solutions using a synthetic benchmark
Sebastian Tarasiuk, Damian Traczuk, Kacper Szczepaniuk, Patryk Stoń, Jakub Smołka157-162
-
Analysis of the usability of daily LiDAR measurements performed using Apple devices
Rafał Porzuc, Piotr Kopniak163-170
-
Comparative analysis of Bootstrap and Foundation CSS frameworks
Dawid Pawelec, Tomasz Szymczyk171-178
-
Comparative analysis of CNN models for handwritten digit recognition
Krystyna Lidia Banaszewska, Małgorzata Plechawska-Wójcik179-185
-
The evolution of Microsoft Windows operating systems after 2001
Bartłomiej Wójtowicz, Norbert Wójcik186-193
-
Comparative analysis of tools for managing web application development
Paulina Wójcik, Małgorzata Plechawska-Wójcik194-198
-
Comparison of performance of Xamarin and Flutter cross-platform frameworks
Piotr Kowalczyk, Mariusz Dzieńkowski199-204
-
Performance comparison of working with a database in Spring Boot version 3.2.3 and Laravel version 8.83.27
Mateusz Zajączkowski205-209
-
Examination of the performance and scalability of a web application in a reactive and imperative approach using the Spring Framework
Karol Lis, Jakub Smołka210-216
-
Comparative analysis of the availability of popular social networking sites
Maciej Ciukaj, Maria Skublewska-Paszkowska217-222
-
Performance analysis of web application client layer development tools us-ing Angular, React and Vue as examples
Damian Bogusz, Paweł Ciszewski, Beata Pańczyk223-230
-
Comparative analysis of database mapping frameworks available in NuGet Manager
Maciej Klimiuk, Paweł Karabowicz, Małgorzata Plechawska-Wójcik231-238
-
A usability analysis of e-commerce systems: Prestashop, Magento and Joomla
Marcin Wijaszka, Mariusz Dzieńkowski239-245
-
Comparative analysis of the Express.js and ElysiaJS frameworks in the context of web application development
Damian Kostrzewa, Marek Miłosz246-250
Main Article Content
DOI
Authors
pawel.karabowicz@pollub.edu.pl
Abstract
Every year amount of data significantly grows. This causes a need of tools capable of processing data as quickly as possible. The aim of this article is to perform a comparative analysis of ORM (Object Relational Mapping) tools available in the NuGet manager. The comparison of tools was carried out on two relational database management systems, PostgreSQL and MySQL. Each tool performed eight DML operations, including SELECT, INSERT and UPDATE operations. The operations were repeated 1, 10, 100, 1000, and 10,000 times, respectively. The execution time of each query was measured using the system StopWatch class available in the .NET environment. The results showed that the best ORM tool turned out to be Dapper.
Keywords:
References
What is an ORM – The Meaning of Object Relational Mapping Database Tools, https://www.freecodecamp.org/news/what-is-an-orm-the-meaning-of-object-relational-mapping-database-tools/, [10.11.2023].
What is SQL (Structured Query Language)?, https://aws.amazon.com/what-is/sql/, [10.06.2024].
K. Barczak, The Examination of SQL Queries Efficiency in Chosen IT System, Journal of Computer Sciences Institute 28 (2023) 186–189, https://doi.org/10.35784/jcsi.3606. DOI: https://doi.org/10.35784/jcsi.3606
P. Rymarski, Analysis of the possibilities of optimizing SQL queries, Master thesis, Lublin University of Technology, Lublin, 2021. DOI: https://doi.org/10.35784/jcsi.2641
Z. Łata, Performance analysis of databases created in virtualized and containerized environment, Master thesis, Lublin University of Technology, Lublin, 2023. DOI: https://doi.org/10.35784/jcsi.3743
S. Cvetković, D. Janković, A Comparative Study of the Features and Performance of ORM Tools in a .NET Environment, In International Conference on Object and Databases (2010) 147–158, https://doi.org/10.1007/978-3-642-16092-9_14. DOI: https://doi.org/10.1007/978-3-642-16092-9_14
M. Myllyaho Forsberg, An evaluation of .NET Object-Relational Mappers in relational databases Entity Framework Core and Dapper, Bachelor thesis, Umeå University, Umeå, 2022.
T. Nowicki, S. Tomczak, Comparative analysis of the time performance of database queries in C# language, Master thesis, Lublin University of Technology, Lublin, 2022. DOI: https://doi.org/10.35784/jcsi.2772
What Is C# Entity Framework? A Comprehensive Guide, https://www.simplilearn.com/tutorials/asp-dot-net-tutorial/entity-framework-in-c-sharp, [10.11.2023].
Welcome To Learn Dapper, https://www.learndapper.com/, [10.11.2023].
NHibernate, https://www.tutorialspoint.com/nhibernate/nhibernate_overview.htm, [10.11.2023].
OrmLite, https://ormlite.com/javadoc/ormlite-core/doc-files/ormlite.html, [10.11.2023].
Baza danych Northwind, https://github.com/harryho/db-samples, [05.06.2024].
Article Details
Abstract views: 259

