private static int GetContestIdFromTeamId(int teamId)
{
using (SqlConnection connection = ConnectionManager.GetConnection())
{
var data = new ActivEarthDataProvidersDataContext(connection);
return (from c in data.TeamDataProviders
where c.id == teamId
select c.contest_id).FirstOrDefault();
}
}