PlanetaryDocs: Better example of keeping database integrity across containers.

[maximecaron]

When updating document, one entry in Documents container and many entry in Meta container is updated.
All those entry need to be updated atomically (either all are updated or none are updated).
Otherwise the 2 container will become out of sync if the service crash after calling HandleMetaAsync but before updating the Document container.

How can this be designed to not leave the data in the DB corrupted?

[roji]

Which database are you using?

[maximecaron]

this would be CosmosDB.
And by "corrupted" what I mean is the Tag table would refer to document that have been deleted or the document could have tag that have not been inserted in the tag table.

In both of those situation it make searching a Document by tag not work correctly.

[roji]

If you're looking for EF using transactions on Cosmos, that's tracked by dotnet/efcore#17308.