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