BenchmarkDotNet=v0.11.1, OS=Windows 10.0.18362
Intel Core i7-8750H CPU 2.20GHz (Max: 2.21GHz) (Coffee Lake), 1 CPU, 12 logical and 6 physical cores
.NET Core SDK=2.2.102
[Host] : .NET Core ? (CoreCLR 4.6.27019.06, CoreFX 4.6.27019.05), 64bit RyuJIT
ShortRun : .NET Core 2.1.13 (CoreCLR 4.6.28008.01, CoreFX 4.6.28008.01), 64bit RyuJIT
| ORM | Method | Return | Mean | Gen 0 | Gen 1 | Gen 2 | Allocated |
|---|
| Hand Coded | SqlCommand | Post | 64.57 us | 1.7500 | 0.8750 | 0.1250 | 10.2 KB |
| Hand Coded | DataTable | dynamic | 68.46 us | 1.6250 | 0.5000 | - | 10.42 KB |
| DbConnector | ReadFirstOrDefault<T> | Post | 72.95 us | 1.8750 | 0.8750 | - | 11.95 KB |
| DbConnector | ReadFirstOrDefault<dynamic> | dynamic | 73.26 us | 2.0000 | 1.0000 | - | 12.7 KB |
| DbConnector | 'Read<T> (buffered)' | Post | 73.91 us | 1.8750 | 0.8750 | - | 12.05 KB |
| Dapper | 'Query<dynamic> (buffered)' | dynamic | 74.93 us | 1.8750 | 0.8750 | - | 11.84 KB |
| DbConnector | 'ReadFirstOrDefault<T> (cached)' | Post | 74.94 us | 1.8750 | 0.8750 | - | 11.66 KB |
| DbConnector | 'Read<T> (unbuffered)' | Post | 75.05 us | 2.1250 | 1.0000 | 0.1250 | 12.45 KB |
| Dapper | 'Query<T> (buffered)' | Post | 77.35 us | 1.8750 | 0.8750 | - | 11.76 KB |
| DbConnector | 'Read<dynamic> (buffered)' | dynamic | 77.95 us | 2.0000 | 1.0000 | 0.1250 | 12.72 KB |
| DbConnector | 'Read<dynamic> (unbuffered)' | dynamic | 80.60 us | 2.1250 | 1.0000 | 0.1250 | 13.08 KB |
| Dapper | 'Contrib Get<T>' | Post | 80.77 us | 2.6250 | 1.2500 | 0.3750 | 12.41 KB |
| Dapper | QueryFirstOrDefault<T> | Post | 81.60 us | 1.8750 | 0.8750 | 0.1250 | 11.45 KB |
| Dapper | QueryFirstOrDefault<dynamic> | dynamic | 84.53 us | 2.3750 | - | - | 11.49 KB |
| Dapper | 'QueryFirstOrDefault<T> (auto connection)' | Post | 98.88 us | 2.2500 | 1.1250 | 0.2500 | 12.88 KB |
| Dapper | 'Query<T> (unbuffered)' | Post | 99.35 us | 1.8750 | 0.8750 | - | 11.87 KB |
| DbConnector | 'ReadFirstOrDefault<T> (auto connection)' | Post | 99.66 us | 2.5000 | 1.2500 | 0.5000 | 13.37 KB |
| Dapper | 'Query<dynamic> (unbuffered)' | dynamic | 106.84 us | 2.0000 | 1.0000 | 0.1250 | 11.91 KB |
| DbConnector | 'ReadFirstOrDefault<T> (cached)(auto connection)' | Post | 111.63 us | 2.2500 | 1.1250 | 0.2500 | 13.09 KB |
| EF Core | 'First (Compiled)' | Post | 137.56 us | 3.0000 | 0.2500 | - | 13.98 KB |
| EF Core | First | Post | 151.05 us | 3.7500 | - | - | 17.97 KB |
| EF Core | SqlQuery | Post | 158.25 us | 4.0000 | - | - | 19.1 KB |
| EF Core | 'First (No Tracking)' | Post | 187.25 us | 3.5000 | 0.7500 | 0.2500 | 19.84 KB |