Hi VSV,
vsv wrote:
i have 2 scenarios.
how to map an entity collection say categories with product.categorytype & visually how to map with the datagridview for Categories collection in the collection hierarcy ProductCategories that contains a Categories Collection & Product Collection.
You could prefetchPath the related entity (Category) and then Eval(ProductCategories.Category.Name) at your DataGridView.
vsv wrote:
2.: If I want to filter Categories Collection based on region selected in Product on rowfocus change in the datagridview of Product, so that the combobox shows only the relevant categories, how to do it?
On the RowFocus or RowChange or whatever the event you want to handle you shoul filter the underlying colelction binded to your combobox based on the values selected. If you use _LLBLGenProDataSource _you can use Parameters to automatically make the filter. For more info read LLBLGenPro Help - Using generated code (Adapter || SS) - Databinding at desing time and runtime - Databinding with ASP.NET 2.0
vsv wrote:
3.If I want to AJAX the above task & have the categories collection obtained separately in a web scenario & cache it, what are the performance implications with llblgenpro.
If you are catching the collection to avoid round trips you could use EntityViews and IPredicatExpression to obtain filtered views of the collection based on certain parameters.
For more info read LLBLGenPro Help - Generated code - (Adapter || SS) - Using the EntityViews with entity collections.
Please let us know if you need more explanation.