mORMot Open Source

As part of a 3-tier architecture (SOA), I need to implement a business function that operates on three different ORM classes, each corresponding to a different table in the database.

My goal is to ensure data consistency by using a transaction: if an error occurs while saving any of the entities, I want all changes to be rolled back.

However, in mORMot 2, the TransactionBegin(Table, SessionID) method appears to support only one class at a time.

Therefore, I am wondering:

         How can I manage a transaction that spans multiple ORM classes (tables) in mORMot?

         Does using transactions in mORMot block other users from accessing or modifying the database during the transaction?

When I connect to an external database like PostgreSQL, when using the MultiFieldsValues function, it returns RowId instead of ID.
why

I am using the Objects property of IdocList.

For example:
var dL: IdocList;
for var d: IdocDicts in dl.Objects('Name=', '')
I found that it skips the d objects that do not have a 'Name'."

It seems like you're trying to iterate through an IdocList and filter or process objects based on their 'Name' property, but the issue is that objects without a 'Name' are being skipped.