Mapping field on relation to mapped field on other relation

Posts   
 
    
adhesion
User
Posts: 7
Joined: 20-Nov-2006
# Posted on: 22-Nov-2006 04:56:18   

I want to map field values so that readonly properties are exposed in a given collection for related fields so that it's easy to databind with the grid I'm using. This works great when mapping the fields across one relation. I'm trying to map fields across two relations though and I haven't figured out how to do this in the designer.

Here's the scenario...

  • Returning a list of Investments (InvestmentsCollection)
  • Each Investment has a related entity representing the Security/Asset (ie: AssetEntity)
  • Each Security has certain related entities for things like "Asset Type" or "Asset Class" (ie: AssetTypeEntity and AssetClassEntity)
  • An investment can only have 1 Security and a Security can only have one Asset Type

I'd like to display the Asset Type description in the InvestmentsCollection, example:

InvestmentsCollection(0).InvestmentID InvestmentsCollection(0).AssetTicker (maps to AssetEntity.Ticker) InvestmentsCollection(0).AssetTypeDescription (maps to AssetEntity.AssetTypeEntity.Description)

Any suggestions?

Thanks.

Otis avatar
Otis
LLBLGen Pro Team
Posts: 39927
Joined: 17-Aug-2003
# Posted on: 22-Nov-2006 09:49:46   

Thats not supported. You could opt for a dynamic or typed list in this situation, unless you want to edit the information.

Frans Bouma | Lead developer LLBLGen Pro