What to do with tracked entities when database is deleted

[smitpatel]

Repro is in #6872 (comment)

We add an entity, save it to database. Now entity is in change tracker.
Then database is recreated with EnsureDeleted/EnsureCreated
Same entity cannot be added again since it is still tracked.

[ardalis]

In particular, if in a test scenario you add one entity to an empty database, then delete the database, then add another new entity, it blows up (using InMemory). Because both are assigned ID 1, which is being tracked.

[smitpatel]

We decided in triage that this is by design. If you delete your database in the middle of processing then your DbContext may not be usable. It would be fine pattern to initialize new DbContext or recreate database at very start of processing.

[ardalis]

Fair enough, thanks.