public static int GetCompetitorCount(int contestId)
{
using (SqlConnection connection = ConnectionManager.GetConnection())
{
var data = new ActivEarthDataProvidersDataContext(connection);
return (from c in data.TeamMemberDataProviders
where c.contest_id == contestId
select c.id).ToList().Count;
}
}