Comparative analysis of the time performance of database queries in C# language
Article Sidebar
Open full text
Issue Vol. 22 (2022)
-
Analysis of the impact of various gamification factors on the level of player satisfaction
Krystian Demidiuk, Małgorzata Plechawska-Wójcik1-7
-
Comparative analysis of the time performance of database queries in C# language
Tomasz Nowicki, Sebastian Tomczak, Grzegorz Kozieł8-12
-
Comparison of selected configuration management systems in Linux
Szymon Dudziak, Natalia Jakubczak, Maciej Pańczyk13-17
-
Comparative analysis of PHP frameworks on the example of Laravel and Symfony
Paulina Garbarz, Małgorzata Plechawska-Wójcik18-25
-
Comparison of frameworks for developing web applications in PHP
Kamil Pawelec, Piotr Kopniak26-34
-
Comparison of web application performance on the example of Laravel and Vaadin frameworks
Jakub Radomski35-39
-
Comparison of ASP.NET Core and Spring Boot ecosystems
Teofil Rozaliuk, Petro Kopyl, Jakub Smołka40-45
-
Tools for modeling and simulating business processes - a comparative analysis
Radosław Lipski, Dominik Lipski46-50
-
Comparative analysis of interface sketch design tools in the context of User Experience
Edyta Kowalczyk, Agnieszka Glinka, Tomasz Szymczyk51-58
-
Comparing the Performance of the Object-Relational Mapping Program-ming Frameworks Available in Java
Mateusz Połeć, Jakub Pitera, Grzegorz Kozieł59-65
Main Article Content
DOI
Authors
Abstract
There are many computer applications in the world that use databases to store, process, and use data. That translates into many different ways of handling these databases. It is therefore difficult to choose a solution that meets the needs of the user. This article compares three C# solutions in terms of time efficiency: the Entity Framework Core application framework, pure SQL queries, and parameterized Prepared Statement queries. The results obtained in the course of the research has shown that the fastest solution is the use of non-parameterised SQL queries. The use of Entity Framework Core is the slowest of the three tested solutions.
Keywords:
References
S. Cvetković, D. Janković, A comparative study of the features and performance of orm tools in a. net environment, International Conference on Object and Databases, Springer, Berlin, Heidelberg, (2010) 147-158. DOI: https://doi.org/10.1007/978-3-642-16092-9_14
H. Schwichtenberg, Modern Data Access with Entity Framework Core, Apress, Essen, Germany, 2018. DOI: https://doi.org/10.1007/978-1-4842-3552-2
D. Bowers, C. Ireland, M. Newton, K. Waugh, Understanding object-relational mapping: A framework based approach, International lournal On Advances in Software 2.2, (2009) 202-216.
B. Meyer, .NET is coming [Microsoft Web services platform], Computer 34.8 (2001) 92-97. DOI: https://doi.org/10.1109/2.940017
E. Meijer, The world according to LINQ, Communications of the ACM 54.10 (2011) 45-51. DOI: https://doi.org/10.1145/2001269.2001285
A. Adya, J. A. Blakeley, S. Melnik, S. Muralidhar, Anatomy of the ado. net entity framework, Proceedings of the 2007 ACM SIGMOD international conference on Management of data (2007) 877-888. DOI: https://doi.org/10.1145/1247480.1247580
M. Mitri, Teaching Tip: Active Learning via a Sample Database: The Case of Microsoft's Adventure Works, Journal of Information Systems Education 26.3 (2015) 177-185.
Article Details
Abstract views: 466
License

This work is licensed under a Creative Commons Attribution-ShareAlike 4.0 International License.
