re: Mapping two Tables to one Entity in the Entity Framework

Orsa — Wed, 08 Jul 2009 04:31:27 GMT

Simon,

can the same thing be done without cutting the properties and deleting CutomerAddress?

Or by creating a new Entity (CustomerWithAddress) that will have the following properties

Name

Line1

Line2

PostCode

I am trying to fnd an example for that with no luck

re: Mapping two Tables to one Entity in the Entity Framework

ukadc — Wed, 15 Jul 2009 11:23:54 GMT

Hi,

I’m not certain I understand what you’re trying to achieve, but basically all this is doing is;

a) Making sure the storage definitions of the two tables is in the EDMX file,

b) Editing the conceptual definitions so that there is a single entity, and finally

c) Editing the mapping to connect the new conceptual definition to the existing tables in the storage space

So if you went through this walkthrough and looked at the XML in the EDMX file this should give you a starting point. Chances are you can do a lot of this by hand if you don’t like the GUI approach.

Does that help?

Simon