ActivEarth.DAO.ContestDAO.GetContestNameFromContestId C# (CSharp) Method

        public static string GetContestNameFromContestId(int contestId)
        {
            using (SqlConnection connection = ConnectionManager.GetConnection())
            {
                var data = new ActivEarthDataProvidersDataContext(connection);
                return (from c in data.ContestDataProviders
                        where c.id == contestId
                        select c.name).FirstOrDefault();
            }
        }