Comparative analysis of the time performance of database queries in C# language
Tomasz Nowicki
tomasz.nowicki1@pollub.edu.plUniversity of Technology, Lublin (Poland)
Sebastian Tomczak
(Poland)
Grzegorz Kozieł
(Poland)
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:
C#, Entity Framework Core, SQL Database, Prepared Statement, .NET FrameworkReferences
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
Google Scholar
H. Schwichtenberg, Modern Data Access with Entity Framework Core, Apress, Essen, Germany, 2018.
DOI: https://doi.org/10.1007/978-1-4842-3552-2
Google Scholar
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.
Google Scholar
B. Meyer, .NET is coming [Microsoft Web services platform], Computer 34.8 (2001) 92-97.
DOI: https://doi.org/10.1109/2.940017
Google Scholar
E. Meijer, The world according to LINQ, Communications of the ACM 54.10 (2011) 45-51.
DOI: https://doi.org/10.1145/2001269.2001285
Google Scholar
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
Google Scholar
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.
Google Scholar
Authors
Sebastian TomczakPoland
Authors
Grzegorz KoziełPoland
Statistics
Abstract views: 306PDF downloads: 264
License
This work is licensed under a Creative Commons Attribution-ShareAlike 4.0 International License.
