Insert only changed columns

[Tiberiu_STOICESCU]

Hello

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

[wlandgraf (Wagner Landgraf)]

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.

[Tiberiu_STOICESCU]

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