Dynamic Joins

Posts   
 
    
hplloyd
User
Posts: 191
Joined: 29-Oct-2004
# Posted on: 17-Nov-2009 10:34:21   

Hi,

I have a view in my SQL 2008 database that I have generated as a TypedView in LLBLGen 2.6 using adapter.

I want to generate a dynamic list from this view which I think I can do relatively easily, however I would like to join my view to one or more tables in my database and include values from these related tables in my dynamic list.

Can you point me to an example/documentation that explains how I join my view to a table because there obviously is no generated RelationInfo code for doing this easily

Many thanks in advance

Huw

Walaa avatar
Walaa
Support Team
Posts: 14993
Joined: 21-Aug-2005
# Posted on: 17-Nov-2009 10:42:37   

how I join my view to a table because there obviously is no generated RelationInfo code for doing this easily

if you want generated Relations, you can try to map the view to an Entity (you may also leave the TypedView as is). And then you can use the Designer to define custom relations between that new entity and other entities.

Otherwise you can define relations in code, using the EntityRelation class. Please check the Reference manual.