Dynamic List - 1 to Many

Posts   
 
    
nw
User
Posts: 42
Joined: 09-Jun-2010
# Posted on: 17-Jun-2010 10:37:00   

With v3.0, if I were to generate a dynamic list based on fields of 3 different tables, A, B and C, and there are joins between A -> B -> C, what would happen if A -> B is a 1 to Many and B->C is a 1 to Many?

Does it get flatten up and fields of A and B just gets repeated in the DataTable?

nw
User
Posts: 42
Joined: 09-Jun-2010
# Posted on: 17-Jun-2010 10:45:33   

Also, how does LLBLGen know that A is primary entity in the example above since the query could also be constructed from C -> B -> A.

Does it depend on the left and right operand in the Relation that you construct, ie left = primary?

FYI, I am using DynamicRelation.

MTrinder
User
Posts: 1461
Joined: 08-Oct-2008
# Posted on: 17-Jun-2010 11:09:02   

Question 1 - Yes. Question 2 - Yes.

We like questions like this...!

Matt

nw
User
Posts: 42
Joined: 09-Jun-2010
# Posted on: 17-Jun-2010 11:10:23   

Thank you simple_smile