Many-to-many relationships in Strongly Typed Datasets

  • Thread starter Thread starter David Benoff
  • Start date Start date
D

David Benoff

I'd like to create a strongly typed dataset with the junction tables
abstracted out of my many-to-many relationships, rather than having to
traverse it programmatically, or denormalize the dataset. This is a major
PITA when iterating through collections with the various ASP web controls.
I've loooked high and low but found no information about doing this, which I
find astonishing. Is there really no way to do this in ADO?

Thanks a bunch,
David Benoff
 
I'd like to create a strongly typed dataset with the junction tables
abstracted out of my many-to-many relationships, rather than having to
traverse it programmatically, or denormalize the dataset. This is a major
PITA when iterating through collections with the various ASP web controls.
I've loooked high and low but found no information about doing this, which I
find astonishing. Is there really no way to do this in ADO?

Thanks a bunch,
David Benoff
Click to expand...

David,

I would think it would be helpful if you create another relation in between
the two relations having the M:N relationships. The new relation should have
both the PK of the two other relations as its primary key.



Sent using the Entourage X Test Drive.
 
Back
Top