wp-dapper-10.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].[BeastLapTimeDriverId]
                WHERE [Tracks].[Id] = 1;";

Track track = (await connection.QueryAsync<Track, Driver>(sql)).FirstOrDefault();