Strongly typed data sets

[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

 

[William Ryan eMVP]

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 ?

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

 

[aguyngueran]

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.

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

 

[William Ryan eMVP]

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.