Comparative analysis of database mapping frameworks available in NuGet Manager

Main Article Content

DOI

Maciej Klimiuk

maciej.klimiuk@pollub.edu.pl

Paweł Karabowicz

pawel.karabowicz@pollub.edu.pl

Małgorzata Plechawska-Wójcik

m.plechawska@pollub.pl

https://orcid.org/0000-0003-1055-5344

Abstract


Every year amount of data significantly grows. This causes a need of tools capable of processing data as quickly as possible. The aim of this article is to perform a comparative analysis of ORM (Object Relational Mapping) tools available in the NuGet manager. The comparison of tools was carried out on two relational database management systems, PostgreSQL and MySQL. Each tool performed eight DML operations, including SELECT, INSERT and UPDATE operations. The operations were repeated 1, 10, 100, 1000, and 10,000 times, respectively. The execution time of each query was measured using the system StopWatch class available in the .NET environment. The results showed that the best ORM tool turned out to be Dapper.


Keywords:

performance analysis, ORM, Dapper, OrmLite

References

Article Details

Klimiuk, M., Karabowicz, P., & Plechawska-Wójcik, M. (2024). Comparative analysis of database mapping frameworks available in NuGet Manager. Journal of Computer Sciences Institute, 32, 231–238. https://doi.org/10.35784/jcsi.6308