Strongly typed data sets

  • Thread starter Thread starter aguyngueran
  • Start date Start date
A

aguyngueran

Hello there,

How can I automatically create strongly typed data set from existing SQL
Server 2000 tables.
I know that I can drag and drop a table to generate one, but I'd like to
generate strongly typed
data set for all specified tables with relations between them ? Is it
possible with Microsoft Visual
Studio Enterprise Architect 2003 or another tool ?

Thank You

Best regards
Rafal Grzybowski
 
aguyngueran said:
Hello there,

How can I automatically create strongly typed data set from existing SQL
Server 2000 tables.
I know that I can drag and drop a table to generate one, but I'd like to
generate strongly typed
data set for all specified tables with relations between them ? Yes
possible with Microsoft Visual
Studio Enterprise Architect 2003 or another tool ?
Click to expand...

This will work. You can just open up server explorer and drag the other
tables into the dataset. You'll get another adapter, choose Generate
Dataset and then choose existing dataset (the one from the first table) and
that'll put them in there. You still need to generate the relationships (I
think - pretty sure about this) but the keys will come in and that's the
tough part. So basically just drag out each table, and when you generate
dataset, just make sure you add them all to the same one.

HTH,

Bill
 
William Ryan eMVP said:
This will work. You can just open up server explorer and drag the other
tables into the dataset. You'll get another adapter, choose Generate
Dataset and then choose existing dataset (the one from the first table) and
that'll put them in there. You still need to generate the relationships (I
think - pretty sure about this) but the keys will come in and that's the
tough part. So basically just drag out each table, and when you generate
dataset, just make sure you add them all to the same one.
Click to expand...

But do I have to generate relationships manually ? I'd like to map about 140
tables
and it'd be very difficult to create it by hand


Best regards
Rafa³ Grzybowski
 
AFAIK, yes, if it will do it for you automatically, I've never gotten it to
work and I've tried a few times. It may be possible, but I really don't
think so.
 
Back
Top