Problem with Typed List and self joined table

Posts   
 
    
like2175
User
Posts: 83
Joined: 27-Mar-2006
# Posted on: 26-Sep-2006 09:01:23   

I have a table of items with pk item_id and 3 other attributes: item_description, from_item_id, to_item_id and main_item_id. The table is joined to itself so that from_item_id, to_item_id and main_item_id must exist in the item_id table.

I now want to fill an asp.net gridview with:

item_id, item_description, from_description, to_description

I've gone into the typed list designer added the item table 3 times but cannot make connections between item.item_id to item.from_item_id anditem.item_id to item_to_item_id

Am I doing something wrong confused ?

I'm trying to convince colleagues that llblgen is the way to go and this is a showstopper.

v1.0.2005.1 Final March 31st 2006

Walaa avatar
Walaa
Support Team
Posts: 14946
Joined: 21-Aug-2005
# Posted on: 26-Sep-2006 09:43:09   

Assuming that the relations are correctly set in the database, andare found in the LLBLGen Pro Designer without any of them being hidden.

In the Designer -> Typed List properties. You should select different Entities from the "Entities selected for this Typed List" List. And then use the "Select alternative" ComboBox to select the appropriate relation you want to use. Don't forget to press the Button "Set".

Also please use the latest release of v1.0.2005.1