is LLBLGen ok with this?

Posts   
 
    
Khou
User
Posts: 46
Joined: 28-Mar-2009
# Posted on: 03-Apr-2009 09:00:48   

see diagram is this ok for llblgen?

Walaa avatar
Walaa
Support Team
Posts: 14983
Joined: 21-Aug-2005
# Posted on: 03-Apr-2009 09:53:30   

No diagram is there.

Khou
User
Posts: 46
Joined: 28-Mar-2009
# Posted on: 04-Apr-2009 10:46:13   

Hi

sorry forgot to attach the diagram , the diagram contains the following example

User can have many of home,work,mobile phone numbers However only the phone numbers in the contactinformation table will be the users primary contact numbers.

ContactInformation -PKContactInformationID etc.. -FKHomePhoneID <---FK1 -FKWorkPhoneID <---FK2 -FKMobilePhoneID <---FK3

Phone -FKPhoneID -PhoneNumber etc..

would LLBLGen be ok with the above design? or it will be confused?

Seth avatar
Seth
User
Posts: 204
Joined: 25-Mar-2006
# Posted on: 05-Apr-2009 00:29:17   

There should be no problem with that. I have done it myself.

Khou
User
Posts: 46
Joined: 28-Mar-2009
# Posted on: 07-Apr-2009 04:04:13   

thanks for the clarification seth

Antonio avatar
Antonio
User
Posts: 67
Joined: 09-Oct-2007
# Posted on: 09-Apr-2009 11:59:26   

Khou wrote:

Hi

sorry forgot to attach the diagram , the diagram contains the following example

User can have many of home,work,mobile phone numbers However only the phone numbers in the contactinformation table will be the users primary contact numbers.

ContactInformation -PKContactInformationID etc.. -FKHomePhoneID <---FK1 -FKWorkPhoneID <---FK2 -FKMobilePhoneID <---FK3

Phone -FKPhoneID -PhoneNumber etc..

would LLBLGen be ok with the above design? or it will be confused?

no problem. You can also rename the properties generated by LLBL.

By default it generates three properties:

Phone
Phone_
Phone__

from LLBL designer you can rename in:

HomePhone
WorkPhone
MobilePhone