title: EF Core Will not delete entry even after eliminating cascading properties
body: <p>To give  simpler version of my database, I have Attorneys, I have Cases and I have CaseParticipations, which, surprise-surprise, has two foreign keys.</p>
  <p>Now, in my API, the delete method for Attorneys starts by first finding all of the CaseParticipations which reference it, deleting them, doing a _context.SaveChanges(), and only then trying to delete the Attorney itself.</p>
  <p>Here's the issue. This never works.</p>
  <p>I implement this api in a website built in blazor and whenever I try to delete the attorney, it only erases its case participations, but stops there. If I rebuild and rerun the application, now the attorney has no case participations and when I try to delete it, it works.</p>
  <p>I've debugged and it seems to be a Sql Server problem, it occurs on the line _context.Attorneys.Remove(att), and it basically says it won't delete the attorney because it still has Case Participations which depend on it and I didn't set it to cascade delete.</p>
  <p>But this shouldn't happen. The Participations were already deleted.</p>
  <p>My attempted fix was to pretend the Attorney entry doesn't get updated and still has 2 case participations in its properties, which don't actually exist in the database, so I tried updating the attorney after deleting the participations but before deleting it, setting its Case Participations property to a new empty collection of case participation, doing a _context.SaveChanges, and relaoding the attorney from context att= _context.Find(id). Still nothing, the same exception is thrown.</p>
  <p>Am I doing something wrong or is this a problem in EF Core 3.1?</p>