I'm using LLBL version 1.0.2005.1 (Adapter scenario) and i'm having a schema like this : - Customers - Orders (detail m:1 to Customers)

I fetch a collection of customers, with prefetched orders, based on criteria from both tables.

What i'm trying to do is databind a control (Repeater) to the Orders (Prefetched Data), and also have access to the columns of the parent table.

Is this possible? Thanks in advance

Like if you want to display the customerName for instance with each row of the orders table. You should use the LLBLGen Pro designer to add an extra field to the OrderEntity; "a field mapped on related field" and map it to Customer.Name

Then with the help of the prefetchPathing that you were using, this field gets loaded. And you can display it in your grid as well.

I read this thread and helped much. Thanks.

I think customerName comes with all instances of OrderEntity. Is there a way that I can specify that I don't need customerName for current instance or do I make a new entity without the customerName column. (for the sake of performance)

My scenario is; 1. Bind all related tables into a grid and display. 2. Allow editing of this grid. 3. Save changes to DB.

In another scenario I may not want to use customerName column.

Hi

I think adding a field to the entity class assumes you want to use it all the time.

If not, why not making a view with corresponding entity or a typedlist or even play with the databound event with a standard parent entity-child entitycollection for your particular scenario?

Projections really worked fine thanks. Now I am trying to figure out the differences between serialization of IList & Projections. I'm going to do some performance tests.

Thanks for support.