Submitted by: Hannes Lowette (hanneslowette)

Attachments:
DmlSqlGenerator.7z

System.InvalidOperationException was unhandled
Message=The property 'ID' is part of the object's key information and cannot be modified.
Source=System.Data.Entity

Put the keyfield to StoreGenereatedpattern="Identity" and another field to Computed. This will cause wrong sql generation and it will try to overwrite the pk of an object. raising the above error.

The field F_PERS_ID is the PK and has Identity set
The field CF_PERS_HAS_MEMO is a calculated DB field.

execute block (
p0 VARCHAR(200) character set utf8 = @p0, p1 BIGINT = @p1)
returns (
"F_PERS_ID" BIGINT, "CF_PERS_HAS_MEMO" INT)
as begin
update "T_PERSON"
set "F_PERS_NAME" = :p0
where ("F_PERS_ID" = :p1)
returning "F_PERS_ID", "CF_PERS_HAS_MEMO" into :"F_PERS_ID", :"CF_PERS_HAS_MEMO";
suspend;
end

Commits: 3f8d2e3