On an ADO.NET application i can show rows of many related tables on a GridVIew using joins. For a update, i make the operation on the right table defining my update statment for that single table.

Ok, now with LLBLGen...

If i use a Collection then i can not show related tables, If i use a TypedView ou TypedList, i can not define make it updated...

how is the recommended way to do this with llblgen?

Hello,

A solution can be using Fields Mapped on related fields.

For that, go to the LLBLGen Pro Designer, open the properties of the your Entity. Go to the Fields mapped on related fields sub tab and add the fields of your related table. If you bind the entitycollection of your modified entity, it would be good.

If i have 3 tables, lets say A,B,C. I can build a Select Statment using joins to show fields from both 3 tables.

Your solution using Fields Mapped, can bring only fields from tables A and B on the Colletion, that is correct?

Is there any other solution?

On an ADO.NET application i can show rows of many related tables on a GridVIew using joins. For a update, i make the operation on the right table defining my update statment for that single table.

Similarly you can use a TypedList, TypedView or a DynamicList to show data from different tables. And when updating/inserting data to a specific table use the corresponding Entity/EntityCollection.