LLBLGEN 4.0 .NET Framework 4.0 VB.NET Windows Application LLBLGEN Runtime framework SQL Server 2008

Hi,

Example: I have the following 2 tables Table : Member Fileds: TitleID, Name, SpouseTitleID, Spouse Name

Table: Title TitleID Description

FK is set as follows Member.TitleID=Title.TitleID Member.SpouseTitleID=Title.TitleID

Now I create one typed list with the above two tables. From Title, I should actually get 2 descriptions because of the join. But the typed list returns only one description from title. How do i resolve this

Did you add the Title entity twice to the TypedList?

Walaa wrote:

Did you add the Title entity twice to the TypedList?

No. Do I have to add twice ?

Yes as the Member entity joins to the Title entity twice. Make sure to select which relation each one of them is using.

Walaa wrote:

Yes as the Member entity joins to the Title entity twice. Make sure to select which relation each one of them is using.

Make sure to select which relation each one of them is using

Make sure in designer right ?

shekar wrote:

Make sure in designer right ?

Yes, in LLBLGen Designer, where you design your TypedList.