@David Lane-Joynt, Welcome to Microsoft Q&A, based on my test, I reproduced your problem.
Please delete all existing migrations from the Migrations Folder.
After deleting these migrations, I find that I could use Add-Migration and Update-DataBase command to update database successfully without the problem.
Hope my advice could help you.
If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.