Hi there
I cannot find any way on how to choose oracle sequence responsible for generating identity of given entity, any ideas?
thanks
hpn
Entity Framework - how to chose a sequence for entity's key?
You should follow this instruction:
1. Import table in EDM Wizard (some field values of table were set with trigger). Generate a *.edmx file.
2. Open this *.edmx in XML-editor, in the CSDL part of the file set StoredGeneratedParttern="Identity" for updatable columns.
As a result, the field value will be updated after the insert command.
1. Import table in EDM Wizard (some field values of table were set with trigger). Generate a *.edmx file.
2. Open this *.edmx in XML-editor, in the CSDL part of the file set StoredGeneratedParttern="Identity" for updatable columns.
As a result, the field value will be updated after the insert command.
To clear the things a bit further - some ORMs assume, that the sequence name is the same as the name of the table - which is not the case in my situation, so I either have to tell EF to use such and such sequence for such and such table, or set it manually, if it's not supported (I guess EF alone doesn't support it, since it's sqlServer centric, but maybe oraDirect can do it behind the scenes?).
thanks for any info
HP
thanks for any info
HP