innerJoinWithDapper.cs

public override IEnumerable<Player> GetAll()
{
    const string sql = "SELECT J.*, T.NM_TIME FROM TB_JOGADOR AS J INNER JOIN TB_TIME AS T ON J.ID_TIME = T.ID";
    
    using (var db = new SqlConnection(ConnectionString))
    {
        var result = db.Query(sql);
        
        return result.Select(player => new Player
        {
            Id = player.ID,
            Name = player.NM_JOGADOR,
            Age = player.NR_IDADE,
            Team = new Team
            {
                Id = player.ID_TIME,
                Name = player.NM_TIME
            }
        });
    }
}