Entity Framework Configuration Question (EF Code-First)

Question

I'm using table per hiearchy for the following model:

Story (base class) - Individual Story (sub class) - Team Story (sub class)

I column in my table that I want to share between both derived types, but I would like to name it differently in each class. Is this possible? I tried a few different things but could not get it to work out correctly (can dig up the exact exception tomrrow at work if need be).

Thanks!

Ladislav Mrnka · Accepted Answer · 2011-07-17 14:18:14Z

1

No it is not possible. The column is mapped to property in the base class and this property is derived in sub classes. You cannot change the name of property in derived class and EF doesn't allow mapping shared properties in derived classes (they must be mapped in the base class).

answered Jul 17, 2011 at 14:18

Ladislav Mrnka

365k60 gold badges666 silver badges673 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Adam Robinson · Accepted Answer · 2011-07-14 02:28:08Z

0

If by "share", you mean that you'd like both subclasses to use that database field (but NOT the base class) just with different names, that should work as long as it's not the discriminator column. Just create scalar properties on each subtype and map the appropriate property to the common field.

answered Jul 14, 2011 at 2:28

Adam Robinson

186k36 gold badges294 silver badges351 bronze badges

4 Comments

Marco Over a year ago

sorry, i had to edit my question. I added a property to Individual Story that matched the exact column name and then I added one to team story with a different name. I added the mapping but failed. Does my edited question change your resonse?

Adam Robinson Over a year ago

@Marco: No, it shouldn't change it. I'll need to know the actual error you're getting to be able to help.

Marco Over a year ago

The column name is TelleId and the error is "Invalid column name 'TelleId1'." and here is my mapping: modelBuilder.Entity<TeamStory>().Property(p => p.TeamLeaderUserId).HasColumnName("TelleId");

Adam Robinson Over a year ago

@Marco: Are you using code-first? If so, I can't help you; you might want to note that in the question.

Collectives™ on Stack Overflow

Entity Framework Configuration Question (EF Code-First)

2 Answers 2

Comments

4 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

4 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related