Comparative analysis of the time performance of database queries in C# language

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 te...

Full description

Bibliographic Details
Published in:	Journal of Computer Sciences Institute
Main Authors:	Tomasz Nowicki, Sebastian Tomczak, Grzegorz Kozieł
Format:	Article
Language:	English
Published:	Lublin University of Technology 2022-03-01
Subjects:	C# Entity Framework Core SQL Database Prepared Statement .NET Framework
Online Access:	https://ph.pollub.pl/index.php/jcsi/article/view/2772

Similar Items

Impact of the persistence layer implementation methods on application per-formance
by: Kamil Siebyła, et al.
Published: (2020-12-01)

Comparative analysis of query execution speed using Entity Framework for selected database engines
by: Krzysztof Winiarczyk, et al.
Published: (2024-03-01)

ASP.NET MVC database applications performance
by: Paweł Borys, et al.
Published: (2018-03-01)

Comparative analysis of selected object-relational mapping systems for the .NET platform
by: Krzysztof Drzazga, et al.
Published: (2020-09-01)

Development of the NIST X-ray Photoelectron Spectroscopy (XPS) Database, Version 5
by: Angela Y. Lee, et al.
Published: (2024-09-01)

ChatbotSQL: Conversational agent to support relational database query language learning
by: Rubén Pérez-Mercado, et al.
Published: (2023-05-01)

O-ODM Framework for Object-Relational Databases
by: Carlos Alberto Rombaldo Jr, et al.
Published: (2012-09-01)

Query Completion for Small-Scale Distributed Databases in PostgreSQL and MongoDB
by: Marin FOTACHE, et al.
Published: (2025-01-01)

GARMT: Grouping-Based Association Rule Mining to Predict Future Tables in Database Queries
by: Peixiong He, et al.
Published: (2025-06-01)

The use of .NET Core in web applications development
by: Ewelina Piątkowska, et al.
Published: (2018-09-01)

SQL queries over encrypted databases: a survey
by: Bo Sun, et al.
Published: (2024-12-01)

Comparative Analysis of ORM Systems for the .NET Platform
by: Tomasz Wiatrowski
Published: (2024-06-01)

The Advantage of NoSQL Databases over SQL Databases
by: Mario-Tudor CHIRIAC
Published: (2025-01-01)

Tuning Database Pada Sistem Penerimaan Mahasiswa Baru Menggunakan Optimasi Query dan Indexing
by: Amat Deska, et al.
Published: (2023-02-01)

Oracle 19c, SQL Server 2019, Postgresql 12 and MySQL 8 database systems comparison
by: Arkadiusz Solarz, et al.
Published: (2020-12-01)

Оптимізаційна модель розташування та постачання альтернативної енергії з використанням просторових даних
by: Мінухін С.В., et al.
Published: (2018-03-01)

Creating Collections with Embedded Documents for Document Databases Taking into Account the Queries
by: Yulia Shichkina, et al.
Published: (2020-05-01)

Performance comparison of relational databases SQL Server, MySQL and PostgreSQL using a web application and the Laravel framework
by: Rafał Wodyk, et al.
Published: (2020-12-01)

“THE NET MONETARY STATEMENT” AND “THE NET NON-MONETARY STATEMENT” – ASSESSMENT INDICATORS FOR THE FINANCIAL POSITION OF THE ENTITY
by: SORIN-CONSTANTIN DEACONU
Published: (2012-10-01)

Considerations on NoSQL Databases
by: Dragoş NICOLAU
Published: (2018-10-01)

Performance analysis of selected database systems: MySQL, MS SQL, PostgerSQL in the context of web applications
by: Katarzyna Lachewicz
Published: (2020-03-01)

A Performance Benchmark for the PostgreSQL and MySQL Databases
by: Sanket Vilas Salunke, et al.
Published: (2024-10-01)

Evaluation of the response time of a geoservice using a hybrid and distributed database
by: Marlen Treviño-Villalobos, et al.
Published: (2022-06-01)

A performance evaluation of in-memory databases
by: Abdullah Talha Kabakus, et al.
Published: (2017-10-01)

Evaluation of Replication Mechanisms on Selected Database Systems
by: Tomáš Pohanka, et al.
Published: (2020-04-01)

Implementing a Synchronization Method between a Relational and a Non-Relational Database
by: Cornelia A. Győrödi, et al.
Published: (2023-09-01)

The Examination of SQL Queries Efficiency in Chosen IT System
by: Krzysztof Barczak
Published: (2023-09-01)

SCHQL (Structure Chinese Query Language): A SQL Parser for Bridging Language Gaps in SQL Environments
by: Bruce W. Mills, DCS, et al.
Published: (2025-09-01)

Performance Evaluation of NewSQL Databases in a Distributed Architecture
by: Zhiyao Zhang, et al.
Published: (2025-01-01)

Database Access through Java Technologies
by: Nicolae MERCIOIU, et al.
Published: (2010-09-01)

The performance of relational and object-relational SQL queries when using Oracle
by: Francisco Javier Moreno Arboleda, et al.
Published: (2005-09-01)

GPT-Based Text-to-SQL for Spatial Databases
by: Hui Wang, et al.
Published: (2025-07-01)

Comparative analysis of databases working under the control of Windows system
by: Serhii Stets, et al.
Published: (2019-12-01)

The Development of a Benchmark Tool for NoSQL Databases
by: Ion LUNGU, et al.
Published: (2013-07-01)

ERPDB: An Integrated Database of ERP Data for Neuroinformatics Research
by: QingHong Yan, et al.
Published: (2007-10-01)

A Novel Database Acceleration Technology for Full Table Scans
by: Chuang Zhang, et al.
Published: (2024-01-01)

A new comparative study of database security
by: Daniel BĂRBULESCU, et al.
Published: (2023-09-01)

Generación automática del diagrama entidad-relación y su representación en SQL desde un lenguaje controlado (UN-LENCEP) Automatic generation of entity-relationship diagram and its representation in SQL from a controlled language (UN-LENCEP)
by: Carlos Mario Zapata Jaramillo, et al.
Published: (2011-01-01)

USING THE DATABASE MANAGEMENT SYSTEM OF THE FINANCIAL STATEMENTS SUBMISSION
by: ALIN ISAC, et al.
Published: (2011-01-01)

Benchmarking Consistency Levels of Cloud-Distributed NoSQL Databases Using YCSB
by: Saulo Ferreira, et al.
Published: (2025-01-01)