Combing tables with one-to-many relationships into a single entities in ADO.NET Entity Framework 4.0

Question

Hi,

I'm aware you can map multiple storage tables to a single entity if they have a one-to-one relationship in EF 4.0.

---

Example:

(storage)

(1)Table: People

Columns: Name, Age

(2)Table: Customers

Columns: Registered

--

Relationship: People <1-1> Customers

(concept)

Entity: Customers

Columns: Name, Age, Registered

---

I'm wondering if it's possible to do this on the "one" side of a one-to-many for ease of use on dynamic data websites?

---

Example:

(storage)

(1)Table: People

Columns: Name, Age

(2)Table: Customers

Columns: Registered

(3)Table: Addresses

Columns: Street City

--

Relationship: Addresses <*-1> People <1-1> Customers

(concept)

*Entity: Customers

Columns: Name, Age, Registered, Street, City

---

Thanks,

Carl

Answer 1

In general, this is called entity splitting, and there's a demo here. However, for your specific case, you might consider refactoring Address into a complex type.