问从DataTable获取List<myModel>

EN

Name  id
Trump  1
Obama  0

class user{
    public string name { get; set; }
    public long id{ get; set; }
}

public List<user> get_users(string user_name)
{
    var user_list = new List<user>();
    using (SqlConnection connection = new SqlConnection(connStr))
    {
        connection.Open();
        using (SqlCommand cmd = new SqlCommand("exec select_user @name='" + + "'", connection))
        {
            SqlDataReader reader = cmd.ExecuteReader();
            while (reader.Read())
            {
                user_list.Add(new user()
                {
                    id = Convert.ToInt64(reader["id"]),
                    name = Convert.ToString(reader["name"]),
                });
            }
        }
        connection.Close();
    }
    return user_list;
}