I am trying to use an llblgenprodatasource loaded with an EtitiyColection (self serv) in an ASP.Net GridView. We must allow editing of a coulple of fields and I need to reference a few fields from a related table in design mode. Typically I would use the standard dot notation to reference nested data ie.

SaleDetail.InvRecord.description

How can nested data be referenced in design mode using this control?

Thanks

Glenn

In the designer edit the SaleDetail entity. Select the Fields on Related Fields tab. Now select the InvRecord.Description item from the drop down and click the add button to add this field to your SaleDetail entity. You will now be able to access SaleDetail.InvRecord.Description using SaleDetail.Description.

You will want to be sure to define the InvRecord prefetch path when you are fetching the SaleDetail collection. Otherwise a separate query would be required for each entity in your collection when you accessed the SaleDetail.Description record.

Terrific! Thanks very much for the solution.

Glenn

Just curious, what code would I need in a sub-class of my standard saledetail entity or saledetailcollection which would accomplish this in a NON Declaritive way. I only need this "view" of the saledetails for 2 specific presentations and I do not need the inv.description property for all the other (many) instanciations of the saledetail entity class.

Thanks

Glenn

You could use a prefetch path to fetch the related entities and in the HTML you could do something like: <%# ((InvRecordEntity)Eval("InvRecord").Description%>

Otis wrote:

You could use a prefetch path to fetch the related entities and in the HTML you could do something like: <%# ((InvRecordEntity)Eval("InvRecord").Description%>

Yes I could but I am trying to use an llblgenprodatasource loaded with an EtitiyColection. I am trying to avoid adding fields on relations for my "standard" saledetails, but make some kind of a subclass which has the additional field. I would then reference this class as the datasource for the llblgenprodatasource.

Thanks

Glenn

glennpd wrote:

Otis wrote:

You could use a prefetch path to fetch the related entities and in the HTML you could do something like: <%# ((InvRecordEntity)Eval("InvRecord").Description%>

Yes I could but I am trying to use an llblgenprodatasource loaded with an EtitiyColection. I am trying to avoid adding fields on relations for my "standard" saledetails, but make some kind of a subclass which has the additional field. I would then reference this class as the datasource for the llblgenprodatasource.

my example is using a related entity, namely the entity returned by the InvRecord property So you just fetch: SaleDetail entities and their related InvRecordEntity entities and at runtime the databinding in the saledetail gridview using the snippet above, will show the description. Of course you have to add a column to the grid which is templated and not bound to a field in the SaleDetail entity. That's teh description column for InvRecord.

I hope I make sense.

Otis wrote:

glennpd wrote:

Otis wrote:

You could use a prefetch path to fetch the related entities and in the HTML you could do something like: <%# ((InvRecordEntity)Eval("InvRecord").Description%>

Yes I could but I am trying to use an llblgenprodatasource loaded with an EtitiyColection. I am trying to avoid adding fields on relations for my "standard" saledetails, but make some kind of a subclass which has the additional field. I would then reference this class as the datasource for the llblgenprodatasource.

my example is using a related entity, namely the entity returned by the InvRecord property So you just fetch: SaleDetail entities and their related InvRecordEntity entities and at runtime the databinding in the saledetail gridview using the snippet above, will show the description. Of course you have to add a column to the grid which is templated and not bound to a field in the SaleDetail entity. That's teh description column for InvRecord.

I hope I make sense.

When I try to create the prefetch path with :

Dim prefetchPath As IPrefetchPath = New PrefetchPath(CInt(EntityType.SaleDetailEntity))

the VS2005 ide says ""EntityType" Type not declared

I don't understand ???

Did you add an Import rootnamespace at the top of your code file?

Otis wrote:

Did you add an Import rootnamespace at the top of your code file?

My face is RED! I had an IMPORT statememnt for AWS which is a class, not AWS_DAL which is the namespace. I am soooo embarassed.

Thanks

Glenn

Is the underlying collection / entity visible from the llblgendatasource?

<%# (SaledetailEntity)eval("inv").description %>

I am trying to place this expression in a format field and saledetailentity is not known.

I think you should be typeCasting to the InvRecordEntity not the SaleDetailEntity. Since you are trying to invoke the InvRecordEntity of the SaleDetailEntity.

Code should look like:

<%# ((InvRecordEntity)Eval("InvRecord")).description %>

Assuming the SaleDetailEntity's InvRecordEntity related field is called "InvRecord". Otherwise change it to the appropriate name.