Framework-Agnostic Query Adaptation: Ensuring SQL Compatibility Across .NET Database Frameworks
| Thesis title in Czech: | Zajištění kompatibility SQL dotazů napříč různými databázovými frameworky v .NET |
|---|---|
| Thesis title in English: | Framework-Agnostic Query Adaptation: Ensuring SQL Compatibility Across .NET Database Frameworks |
| Key words: | porovnání ORM|překlad ORM|optimalizace|výkon dotazování |
| English key words: | ORM comparison|ORM translation|optimization|query performance |
| Academic year of topic announcement: | 2024/2025 |
| Thesis type: | diploma thesis |
| Thesis language: | angličtina |
| Department: | Department of Software Engineering (32-KSI) |
| Supervisor: | Ing. Pavel Koupil, Ph.D. |
| Author: | Mgr. Milan Abrahám - assigned and confirmed by the Study Dept. |
| Date of registration: | 20.11.2024 |
| Date of assignment: | 20.11.2024 |
| Confirmed by Study dept. on: | 26.11.2024 |
| Date and time of defence: | 09.09.2025 09:00 |
| Date of electronic submission: | 16.07.2025 |
| Date of submission of printed version: | 17.07.2025 |
| Date of proceeded defence: | 09.09.2025 |
| Opponents: | doc. RNDr. Irena Holubová, Ph.D. |
| Guidelines |
| There are numerous .NET frameworks available for accessing database systems, each with its own unique features and methods for executing SQL queries. These frameworks differ in their support for database functionalities, and when an application is migrated from one .NET framework to another, query compatibility issues may arise. For example, certain features or SQL constructs supported by one framework may not be available in another, leading to difficulties in query execution and application performance.
The goal of this thesis is to perform a static and experimental comparison of selected .NET frameworks used for database access, focusing on their query execution capabilities and feature support. The student will analyze differences in how these frameworks handle SQL queries and identify potential compatibility issues when switching between frameworks. Based on the findings, the student will design a solution to adapt queries when migrating between frameworks, ensuring smooth transitions even when feature support varies across frameworks. |
| References |
| (1) CALVANESE, Diego, et al. What is query rewriting?. In: International Workshop on Cooperative Information Agents. Berlin, Heidelberg: Springer Berlin Heidelberg, 2000. p. 51-59.
(2) Wide World Importers sample databases for Microsoft SQL https://learn.microsoft.com/en-us/sql/samples/wide-world-importers-what-is?view=sql-server-ver16 (3) Dapper Repository https://github.com/DapperLib/Dapper (4) PetaPoco Repository https://github.com/CollaboratingPlatypus/PetaPoco (5) RepoDB documentation https://repodb.net (6) NHibernate https://nhibernate.info (7) Entity Framework Core https://learn.microsoft.com/cs-cz/ef/core/ (8) linq2db Repository https://github.com/linq2db/linq2db |