Hi,

is it possible at design-time to use a prefetch path for databinding in adapter scenario? Or do I have to build a TypedList?

For example:

CustomerEntity AddressEntity

The GridView should display Customer.Number, Customer.Address.Name etc.

The details should display something like this:

Textbox1.Text = Customer.Number Textbox2.Text = Customer.Address.Name

I need helpful suggetions please

Kindly regards, Carlo

1- If the Grid will be read only, use a TypedList or a DynamicList.

2- If not, then use prefetchPaths in the fetch method to fetch related entities as well, this will issue one database call for example to fetch all customers for all orders, and hence will disable LazyLoading (in case of SelfServicing).

3- You can specify excludedIncludedFields list to execlude fields from being fetched. this is also true in the prefetched related entities.

I guess the ASP.NET 2.0 databinding example, in the v.2.5 download section has many useful examples.

Walaa wrote:

2- If not, then use prefetchPaths in the fetch method to fetch related entities as well, this will issue one database call for example to fetch all customers for all orders, and hence will disable LazyLoading (in case of SelfServicing).

Ok, but I want to bind some fields (ex. Customer.Address.Name) @ Design-Time. The problem is that only the fields from the root entity are selectable. Maybe that issue is related to the cardinality of the relation?

At runtime the prefetchpath works as expected.

Regards, Carlo

Walaa wrote:

2- If not, then use prefetchPaths in the fetch method to fetch related entities as well, this will issue one database call for example to fetch all customers for all orders, and hence will disable LazyLoading (in case of SelfServicing).

Ok, but I want to bind some fields (ex. Customer.Address.Name) @ Design-Time. The problem is that only the fields from the root entity are selectable. Maybe that issue is related to the cardinality of the relation?

At runtime the prefetchpath works as expected.

Regards, Carlo

Ok, but I want to bind some fields (ex. Customer.Address.Name) @ Design-Time. The problem is that only the fields from the root entity are selectable. Maybe that issue is related to the cardinality of the relation?

Currently not supported, similar discussion was held here: http://www.llblgen.com/TinyForum/Messages.aspx?ThreadID=13130