Multiple key fields

Posts   
 
    
JMichelson
User
Posts: 34
Joined: 27-Dec-2003
# Posted on: 04-May-2004 19:14:06   

Hello Frans.

How does LLBLGenPro handle SQL Server tables with multiple key fields? The "linker" tables that I use in my m:m relationships typically contain the two key fields of the associated tables:

Employee (key empKey)---- LinkerTable (keys empKey and divKey) ----- Department (key divKey)

However, the created LinkerTableEntity seems to recognize only the first of the two key fields as "IsPK". Therefore, there doesn't seem to be an easy way to create a LinkerTableEntity object by sending the factory a collection of key fields.

Does this make any sense? How do I handle such situations?

Thanks. Jeff

Otis avatar
Otis
LLBLGen Pro Team
Posts: 39614
Joined: 17-Aug-2003
# Posted on: 04-May-2004 20:18:19   

This was related to an issue with OleDb and the sqlserver driver. Could you please use the latest version and refresh your catalog and see if this fixes your problem?

Frans Bouma | Lead developer LLBLGen Pro
JMichelson
User
Posts: 34
Joined: 27-Dec-2003
# Posted on: 04-May-2004 21:40:16   

Worked! Thanks.

By the way, the install to the newer version went very smoothly.

Otis avatar
Otis
LLBLGen Pro Team
Posts: 39614
Joined: 17-Aug-2003
# Posted on: 04-May-2004 21:46:30   

smile

Frans Bouma | Lead developer LLBLGen Pro