public static List<int> GetContestIdsFromGroupId(int groupId)
{
using (SqlConnection connection = ConnectionManager.GetConnection())
{
var data = new ActivEarthDataProvidersDataContext(connection);
return (from c in data.TeamDataProviders
where c.group_id == groupId
select c.contest_id).ToList();
}
}