Trying to map values to a single DTO

public IEnumerable<Genre> getAllGenres()
{
    List<Genre> genres = new List<Genre>();

    using(SqlConnection connection = new SqlConnection(connectionString))
    {
        connection.Open();

        using(SqlTransaction transaction = connection.BeginTransaction(System.Data.IsolationLevel.ReadCommitted))
        {
            using (SqlCommand command = new SqlCommand("SELECT [id],[genre] FROM [dbo].[genres]", connection, transaction))
            {
                using (SqlDataReader reader = command.ExecuteReader())
                {

                    while (reader.Read())
                    {
                        genres.Add(new Genre()
                        {
                            Id = (int)reader["id"],
                            Name = (string)reader["genre"],
                        });
                    }
                }
            }

            transaction.Commit();

        }
    }

    return genres;
}