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.