public static Statistic GetStatisticFromChallengeId(int challengeId)
{
using (SqlConnection connection = ConnectionManager.GetConnection())
{
var data = new ActivEarthDataProvidersDataContext(connection);
return (Statistic)(from c in data.ChallengeDataProviders
where c.id == challengeId
select c.statistic).FirstOrDefault();
}
}