Abstract
.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.
Sign-in/Register to access full text options 
Talk to us
Join us for a 30 min session where you can share your feedback and ask us any queries you have
Schedule a callDisclaimer: All third-party content on this website/platform is and will remain the property of their respective owners and is provided on "as is" basis without any warranties, express or implied. Use of third-party content does not indicate any affiliation, sponsorship with or endorsement by them. Any references to third-party content is to identify the corresponding services and shall be considered fair use under The CopyrightLaw.
