public static bool RemoveInitializationValues(int challengeId)
{
try
{
using (SqlConnection connection = ConnectionManager.GetConnection())
{
var data = new ActivEarthDataProvidersDataContext(connection);
var toDelete = (from c in data.ChallengeInitializationDataProviders
where c.challenge_id == challengeId
select c).ToList();
foreach (ChallengeInitializationDataProvider row in toDelete)
{
data.ChallengeInitializationDataProviders.DeleteOnSubmit(row);
}
data.SubmitChanges();
return true;
}
}
catch (Exception)
{
return false;
}
}