ActivEarth.DAO.TeamDAO.GetCompetitorCount C# (CSharp) Method

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