public static void Delete(int projectId)
{
DataClassesBugTrackingSystemDataContext db = new DataClassesBugTrackingSystemDataContext();
// delete all project bugs
foreach (Bug bug in db.Bugs.Where(p => p.ProjectId == projectId))
{
db.Bugs.DeleteOnSubmit(bug);
}
Project ProjectToDelete = db.Projects.Single(t => t.ProjectId == projectId);
db.Projects.DeleteOnSubmit(ProjectToDelete);
db.SubmitChanges();
}