VB.NET Syntax for data relations
I'm using the dataset helper class to join datatables. I need to join datatables with multiple primary/foreign keys, but I can't find the syntax for Data.DataRelations.Relations.Add that allows joining more than one column. Is it possible to do this?
Thanks.
Software/Hardware used:
Software/Hardware used:
ASKED:
January 16, 2005 6:57 PM
UPDATED:
January 17, 2005 5:56 AM
Answer Wiki:
some questions that may help clarify:
a) are compound PK/FK required? if design is still flexible, use of single artificial (meaningless) PK is often preferable, with UNIQUE asserted over alternate (compound key) attributes. May be cast "in stone" though ...
b) a VIEW established to project the data your application requires could be useful, not only to bypass compound key complexities but in fact to "project" the data your app really wants.
My take is that if your app is asking for specific table and column data from a number of sources, it knows too much about the DB schema already.
As for some clever VB syntax miracle/workaround, I have no idea.
HTH
To see all answers submitted to the Answer Wiki: View Answer History.
RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
