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?

Answer 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'. =)

Answer 2

See this video. http://www.msteched.com/2010/NorthAmerica/DEV305