Logo des Repositoriums
 
Konferenzbeitrag

Efficient handling of recursive relationships in ORM frameworks using Entity Framework Core as an example

Vorschaubild nicht verfügbar

Volltext URI

Dokumententyp

Text/Conference Paper

Zusatzinformation

Datum

2023

Zeitschriftentitel

ISSN der Zeitschrift

Bandtitel

Quelle

Verlag

Gesellschaft für Informatik e.V.

Zusammenfassung

ORM frameworks are a popular method to bridge the differences between object-oriented programming and relational data management. At the same time, recursive relationships are present in many schemas to represent tree-like or net-like structures. This paper discusses how to efficiently build and execute queries for data with recursive relationships in ORM frameworks. Five possible solutions are conceived and then implemented in Entity Framework Core (EF Core), while making sure that they can be used like regular LINQ queries. Next, the solutions are tested with different SQL dialects. The results of these tests are then analyzed by a variety of test parameters. This analysis shows that queries with recursive common table expressions and queries using key loading are the most efficient. Queries with auxiliary property, vertical unrolling or horizontal unrolling are either too slow or only usable under particular circumstances. The analysis also shows that the performance of the solutions is always dependent on the circumstances, especially the SQL dialect.

Beschreibung

Killisch, Benjamin Uwe (2023): Efficient handling of recursive relationships in ORM frameworks using Entity Framework Core as an example. BTW 2023. DOI: 10.18420/BTW2023-78. Bonn: Gesellschaft für Informatik e.V.. ISBN: 978-3-88579-725-8. pp. 1105-1111. Dresden, Germany. 06.-10. März 2023

Zitierform

Tags