ActivEarth.DAO.GroupDAO.GetAllGroups C# (CSharp) Метод

        public static List<Group> GetAllGroups()
        {
            List<Group> allGroups = new List<Group>();

            using (SqlConnection connection = ConnectionManager.GetConnection())
            {
                var data = new ActivEarthDataProvidersDataContext(connection);

                List<int> groupIds = (from g in data.GroupDataProviders
                                      select g.id
                                      ).ToList();

                foreach (int groupId in groupIds) {
                    Group group = GetGroupFromGroupId(groupId);
                    allGroups.Add(group);
                }

                return allGroups;
            }
        }