The “disappointing [1: 1] mapping” between entities and tables can disappoint you in two ways: not being able to populate an entity from multiple tables and not being able to populate multiple objects from a single table.
It seems to you that you are more interested in the latter, it is possible with most ORMs, even if only by defining different mappings for the same table in separate “instances” of the ORM display. The solution for the Entity Framework is described here and here .
source
share