Below is the mapping of my table. The table has a compound key HERKUNFTCD and LEBENSMITTELCD are FKs to one table and NAEHRWERTCD is a FK to another table. All 3 together are identifying.
I am unsure, how to map this. The Proxy is bound to HERKUNFTCD only.
[Entity]
[Model('Default')]
[Model('BLS')]
[Table('TBLNAEHRWERT')]
[Id('FHERKUNFTCD', TIdGenerator.None)]
// [Id('FLEBENSMITTELCD', TIdGenerator.None)]
[Id('FNAEHRWERTCD', TIdGenerator.None)]
TTBLNAEHRWERT = class
private
[Column('WERT', [])]
FWERT: Nullable<Double>;
[Association([TAssociationProp.Lazy, TAssociationProp.Required], CascadeTypeAll - [TCascadeType.Remove])]
[JoinColumn('HERKUNFTCD', [TColumnProp.Required], 'HERKUNFTCD')]
[JoinColumn('LEBENSMITTELCD', [TColumnProp.Required], 'LEBENSMITTELCD')]
FHERKUNFTCD: Proxy<TTBLLEBENSMITTEL>;
[Association([TAssociationProp.Lazy, TAssociationProp.Required], CascadeTypeAll - [TCascadeType.Remove])]
[JoinColumn('NAEHRWERTCD', [TColumnProp.Required], 'NAEHRWERTCD')]
FNAEHRWERTCD: Proxy<TKATNAEHRWERT>;
function GetHERKUNFTCD: TTBLLEBENSMITTEL;
procedure SetHERKUNFTCD(const Value: TTBLLEBENSMITTEL);
function GetNAEHRWERTCD: TKATNAEHRWERT;
procedure SetNAEHRWERTCD(const Value: TKATNAEHRWERT);
public
property WERT: Nullable<Double> read FWERT write FWERT;
property HERKUNFTCD: TTBLLEBENSMITTEL read GetHERKUNFTCD write SetHERKUNFTCD;
property NAEHRWERTCD: TKATNAEHRWERT read GetNAEHRWERTCD write SetNAEHRWERTCD;
end;