How to map 2+ entities to same table in .NET Entity Framework?

Question

I'm trying to create 2 entities that operate as different views on the same underlying db table. When I create these in Visual Studio's entity model and place an association between them, I get a "Association is not mapped" error. I read an article (http://blogs.msdn.com/adonet/archive/2008/12/05/table-splitting-mapping-multiple-entity-types-to-the-same-table.aspx) that describes how to hand-code the XML in the edmx to add a ReferentialConstraint but that didn't help me any.

Any thoughts? Does the designer not support this?

Duplicate, same user: stackoverflow.com/questions/543604/… — Craig Stuntz
– Craig Stuntz, Commented Feb 12, 2009 at 22:18
I am looking to do the same thing. Basically I have "FooTable" that I would like to represent as "Bar" and "Fu" entities based upon FooTable.FooType — Jim Mitchener
– Jim Mitchener, Commented Nov 4, 2009 at 19:16
jcm - I gave up on this. I'm pretty sure the designer does not support this. — Keith
– Keith, Commented Nov 5, 2009 at 17:32
Craig - this is not a duplicate. my other question is for the vice-versa scenario. — Keith
– Keith, Commented Nov 5, 2009 at 17:33

kdawg · Accepted Answer · 2010-01-11 21:09:34Z

1

From the error, I'd guess that there wasn't an Association created for the storage schema in the edmx (the SSDL of the edmx XML). A conceptual association has been created if you can see it in the designer, but there's no storage definition behind the scenes. I'm guessin'. =)

answered Jan 11, 2010 at 21:09

kdawg

2,01921 silver badges31 bronze badges

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

Collectives™ on Stack Overflow

How to map 2+ entities to same table in .NET Entity Framework?

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related