OrmBenchmark
The goal of the ORM Benchmarking project is to determine how long it takes to execute select statement(s) against a MS SQL Server database and map the returned data to POCO/Dynamic objects in different ORMs. This program executes .Net Framework and .Net Core performance tests for supporting ORMs.
Performance Tests
The performance tests are broken in the following lists:
-
Performance test of executing one sql command frequently (500 times):
- Performance of execute one select statement and map a returned row to a POCO object over 500 iterations
- Performance of execute one select statement and map a returned row to a dynamic object over 500 iterations
-
Performance test of mapping database records to POCO/Dynamic objects (5000 row):
- Performance of mapping 5000 rows returned by one select to POCO objects in one iteration
- Performance of mapping 5000 rows returned by one select to Dynamic objects in one iteration
Testing ORMs
Here is list of ORMs and data access technologis that this program tests.
- Pure Ado
- Dapper
- PetaPoco
- ServiceStack.OrmLite
- EntityFramework
- InsightDatabase
- SimpleData
- OrmToolkit
- DevExpress Xpo (Not working with Local DB mode )
How to run the benchmarks
Just download the project and run it or add your favorite ORM as a plugin to the project.
- For testing .Net Framework ORMs run OrmBenchmark.Console project.
- For testing .Net Core ORMs run OrmBenchmark.Console.NetCore project.