wp-dapper-08.cs

string sql = $@"SELECT [Tracks].[Id], [Tracks].[Title],
                       [Drivers].[Id], [Drivers].[FirstName], [Drivers].[LastName], [Drivers].[ChampionTitleCount] 
                FROM [Tracks] 
                INNER JOIN [Drivers]
                ON [Drivers].[Id] = [Tracks].[BestLapTimeDriverId]
                WHERE [Tracks].[Id] = 1;";

Track track = (await connection.QueryAsync<Track, Driver, Track>(sql, (t, d) =>
{
    t.BestLapTimeDriver = d;

    return t;
})).FirstOrDefault();