public static bool RemoveContestFromContestId(int contestId)
{
try
{
using (SqlConnection connection = ConnectionManager.GetConnection())
{
var data = new ActivEarthDataProvidersDataContext(connection);
ContestDataProvider dbContest =
(from c in data.ContestDataProviders where c.id == contestId select c).FirstOrDefault();
if (dbContest != null)
{
data.ContestDataProviders.DeleteOnSubmit(dbContest);
data.SubmitChanges();
}
return true;
}
}
catch (Exception)
{
return false;
}
}