Best Practise - Multi Field Key Relations

Posts   
 
    
ianvink
User
Posts: 394
Joined: 15-Dec-2006
# Posted on: 11-Apr-2007 16:43:47   

C#, March 2st Build, V2

[Note: I can't change the database rage ] ** SQL Schema Info:**

I have a parent table with a primary key a composite of 5 fields (yes 5rage ) The child table has a primary key of 2 fields. The relationship between the two tables used 2 common fields.

My question is:

How do I create a relationship between the parent/child so that in code I could write something like MyParent.MyChilds after I call MyParent.GetMulti(...)

Is there a place in the **MyParentEntity **code I could use partial classes to add this relationship so that the other developers don't have to each time add this complex relationship?

Thanks, Ian

Walaa avatar
Walaa
Support Team
Posts: 14995
Joined: 21-Aug-2005
# Posted on: 11-Apr-2007 17:19:19   

I think you have posted a similar question before: http://www.llblgen.com/tinyforum/Messages.aspx?ThreadID=8605

ianvink
User
Posts: 394
Joined: 15-Dec-2006
# Posted on: 11-Apr-2007 17:54:58   

Ugh.

Too many long days behind the PC....

thanks