This week's book giveaway is in the OO, Patterns, UML and Refactoring forum. We're giving away four copies of Refactoring for Software Design Smells: Managing Technical Debt and have Girish Suryanarayana, Ganesh Samarthyam & Tushar Sharma on-line! See this thread for details.
I have Composite Primary key and foreign key which is also composite key. one of the column is same...
i.e. Table Group has composite Id PRIMARY KEY(gId, cId) [ Where cId is primary key of other table ]
Now Table GroupMember has composite primary key PRIMARY KEY(gmid, cId ) [ Where cId is primary key of other table ].
GroupMember also has foreign key fkgroup REFERENCES Group(gid, cId) (which is composite key as mentioned above]
Now, when I attemt to save GroupMember instance, foreign key (fkgroup) is not inserted. In many-to-one relationship I cannot set insert=true because cId is part of primary key for both GroupMember and Group Table.
How do I persist column fkgroup of GroupMemeber table?
I’ve looked at a lot of different solutions, and in my humble opinion Aspose is the way to go. Here’s the link: http://aspose.com