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 MethodReturnMeanGen 0Gen 1Gen 2Allocated
Hand CodedSqlCommandPost64.57 us1.75000.87500.125010.2 KB
Hand CodedDataTabledynamic68.46 us1.62500.5000-10.42 KB
DbConnectorReadFirstOrDefault<T>Post72.95 us1.87500.8750-11.95 KB
DbConnectorReadFirstOrDefault<dynamic>dynamic73.26 us2.00001.0000-12.7 KB
DbConnector'Read<T> (buffered)'Post73.91 us1.87500.8750-12.05 KB
Dapper'Query<dynamic> (buffered)'dynamic74.93 us1.87500.8750-11.84 KB
DbConnector'ReadFirstOrDefault<T> (cached)'Post74.94 us1.87500.8750-11.66 KB
DbConnector'Read<T> (unbuffered)'Post75.05 us2.12501.00000.125012.45 KB
Dapper'Query<T> (buffered)'Post77.35 us1.87500.8750-11.76 KB
DbConnector'Read<dynamic> (buffered)'dynamic77.95 us2.00001.00000.125012.72 KB
DbConnector'Read<dynamic> (unbuffered)'dynamic80.60 us2.12501.00000.125013.08 KB
Dapper'Contrib Get<T>'Post80.77 us2.62501.25000.375012.41 KB
DapperQueryFirstOrDefault<T>Post81.60 us1.87500.87500.125011.45 KB
DapperQueryFirstOrDefault<dynamic>dynamic84.53 us2.3750--11.49 KB
Dapper'QueryFirstOrDefault<T> (auto connection)'Post98.88 us2.25001.12500.250012.88 KB
Dapper'Query<T> (unbuffered)'Post99.35 us1.87500.8750-11.87 KB
DbConnector'ReadFirstOrDefault<T> (auto connection)'Post99.66 us2.50001.25000.500013.37 KB
Dapper'Query<dynamic> (unbuffered)'dynamic106.84 us2.00001.00000.125011.91 KB
DbConnector'ReadFirstOrDefault<T> (cached)(auto connection)'Post111.63 us2.25001.12500.250013.09 KB
EF Core'First (Compiled)'Post137.56 us3.00000.2500-13.98 KB
EF CoreFirstPost151.05 us3.7500--17.97 KB
EF CoreSqlQueryPost158.25 us4.0000--19.1 KB
EF Core'First (No Tracking)'Post187.25 us3.50000.75000.250019.84 KB