StoreGeneratedPattern.Computed
------------------------------
Key: DNET-258
URL: http://tracker.firebirdsql.org/browse/DNET-258
Project: .NET Data provider
Issue Type: Bug
Environment: FB 2.5, EF 3.5, VS 2010
Reporter: Hannes Lowette
Assignee: Jiri Cincura
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
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
------------------------------------------------------------------------------
_______________________________________________
Firebird-net-provider mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
