Insert only changed columns


In "TMS Aurelius Documentation" I read:
" When updating objects, Aurelius detects which property have changed since the entity was loaded from the database in the manager, and it only updates those columns in the database"

It is possible when I insert a new object to specify in INSERT stament only columns that are changed by an assigment?

Best regards,
Tiberiu Stoicesci

Aurelius can't track what has been modified in an INSERT because the object is not yet in the manager when it's saved, so it can't compare current state with previous state.

But Aurelius doesn't include NULL values in insert. Thus, if your property is nullable and you haven't modified it, it won't be included in INSERT.

I understand that the recommended option is to use Nullable for the columns for which I want to remain unchanged at the insert.

Thank you

1 Like

This topic was automatically closed 60 minutes after the last reply. New replies are no longer allowed.