Defining key for derived entities from base Entity

Question

I want to derive TimeCondition entity from Condition entity, so I created this model (with abstract Condition):

enter image description here

but on validation, it says:

Error 3 Error 159: EntityType 'SHomeModel.Store.TimeCondition' has no key defined. Define the key for this EntityType. E:\proj\SmartHome.edmx 126

How can I define TimeCondition's key to be Condition's Id ?

Majid · Accepted Answer · 2014-03-21T10:26:52.727

1

Note that your table in database should have primary key but in EDMX file you should remove it from your child entity to let it to use parent's key!

edited Mar 21 '14 at 10:26

answered Mar 21 '14 at 09:57

Majid

score -1 · Answer 2 · answered Mar 21 '14 at 07:27

-1

You have to give Condition's Id to the TimeCondidtion as a foreign key. And then update the Entity model.

answered Mar 21 '14 at 07:27

Pratik Bhoir

2 Answers2