public static List<Group> GetGroupsByUser(int userID)
{
List<Group> toReturn = new List<Group>();
using (SqlConnection connection = ConnectionManager.GetConnection())
{
var data = new ActivEarthDataProvidersDataContext(connection);
List<int> groupIds = (from u in data.GroupMemberDataProviders
where u.user_id == userID
select u.group_id
).ToList();
foreach (int groupId in groupIds)
{
toReturn.Add(GetGroupFromGroupId(groupId));
}
}
return toReturn;
}