Hi,

Is it possible to obtain the Primary key name of an entity in an lpt template. The Primary key is not included in the IEntityMapTargetElement.UniqueConstraints (logically).

t.i.a Arjan Vermunt

What exactly do you mean with PK name? The fields which make up the PK?

IEntityMapTargetElement is the target an entity is mapped on. You miss fields if you look at that object, you should look at the EntityDefinition object. That object contains a PrimaryKeyFields collection.

In an entity which is in a hierarchy of TargetPerEntityHierarchy, the PK fields are defined in the ROOT of the hierarchy. All other entities (thus subtypes) have no pk fields defined, as these are in the supertype and inherited from the supertype. So test on that.

For the other situations (targetperentity and no inheritance) the pk fields are in that collection.

I mean the name of the Primary key in f.i. Oracle. This name also appears in the database exception when a duplicate record is trying to be added.

So the PK fields of the table? As the unique constraint name for the PK isn't read from the db, just the PK fields. Most databases don't assign a name to the PK constraint.