Author:
Nowicki Tomasz,Tomczak Sebastian,Kozieł Grzegorz
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.
Subject
Polymers and Plastics,General Environmental Science
Reference7 articles.
1. 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.
2. H. Schwichtenberg, Modern Data Access with Entity Framework Core, Apress, Essen, Germany, 2018.
3. 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.
4. B. Meyer, .NET is coming [Microsoft Web services platform], Computer 34.8 (2001) 92-97.
5. E. Meijer, The world according to LINQ, Communications of the ACM 54.10 (2011) 45-51.