Comparative analysis of database mapping frameworks available in NuGet Manager

Maciej Klimiuk

maciej.klimiuk@pollub.edu.pl
Department of Computer Science, Lublin University of Technology (Poland)

Paweł Karabowicz

Department of Computer Science, Lublin University of Technology (Poland)

Małgorzata Plechawska-Wójcik

Department of Computer Science, Lublin University of Technology (Poland)
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