Fetch performance comparison of object relational mapper in .NET platform
Witoon Wiphusitphunpol, Thitiporn Lertrusdachakul · 2017
.NET platform is increasingly being used in software development industry. Many data access technologies have been developed on this platform, thus choosing a suitable technology has become a difficult task. In this paper, an empirical study on fetch performance comparison by conducting experiments on common test data set of selected data access libraries; ADO.NET, Dapper and Entity Framework Core with tracking and no-tracking change is investigated. The results show that ADO.NET is the fastest when query a few result, though it is just slightly different from the others. However, in repeatedly query the same large number of results, Entity Framework Core yields the fastest query time and consumes the highest memory while ADO.NET consumes the least memory. From the overall result, Entity Framework Core is recommended for software that do not require high concurrently data access and running in low memory environment. Dapper is suitable for software that require high concurrently data access and ADO.NET is suitable for software that running on low memory environment.