Accessing entity fields from a JOIN?

Posts   
 
    
benles
User
Posts: 62
Joined: 02-May-2005
# Posted on: 29-Jun-2005 21:24:02   

Suppose I have this query:

SELECT a., b. FROM a JOIN b on a.id = b.id

When I call GetMulti() on A's collection, I can access A's entity fields. How do I access the entity fields from B?

Otis avatar
Otis
LLBLGen Pro Team
Posts: 39933
Joined: 17-Aug-2003
# Posted on: 29-Jun-2005 22:03:07   

Entities span 1 table for now (will change soon). So if you want fields from multiple entities, in your case a and b, create a typed list or a dynamic list. Please consult the documentation about typed lists for details.

Frans Bouma | Lead developer LLBLGen Pro
benles
User
Posts: 62
Joined: 02-May-2005
# Posted on: 29-Jun-2005 22:08:53   

Otis wrote:

Entities span 1 table for now (will change soon). So if you want fields from multiple entities, in your case a and b, create a typed list or a dynamic list. Please consult the documentation about typed lists for details.

Creating a view can also be an easy workaround.