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;
}
}