ActivEarth.DAO.UserDAO.GetAllUsers C# (CSharp) Метод

        public static ObservableCollection<User> GetAllUsers()
        {
            var allUsers = new ObservableCollection<User>();
            using (SqlConnection connection = ConnectionManager.GetConnection())
            {
                var data = new ActivEarthDataProvidersDataContext(connection);
                var userData = (from u in data.UserDataProviders
                                join p in data.ProfileDataProviders on u.id equals p.user_id
                                select
                                    new User
                                    {
                                        UserName = u.user_name,
                                        UserID = u.id,
                                        Email = p.email,
                                        FirstName = p.first_name,
                                        LastName = p.last_name,
                                        City = p.city,
                                        State = p.state,
                                        Gender = p.gender,
                                        ProfileID = p.id,
                                        Age = p.age,
                                        Weight = p.weight,
                                        Height = p.height,
                                        GreenScore = p.green_score,
                                        ActivityScore = new ActivityScore(
                                            p.activity_score_badges,
                                            p.activity_score_challenges,
                                            p.activity_score_contests)
                                    });

                foreach (var user in userData)
                {
                    allUsers.Add(user);
                }
            }
            return allUsers;
        }