Building DataSets using SQL Servers MetaData

[Geir Holme]

Hi all.
Using Visual Studio VB.NET and SQL Server 2000.
When I drag tables from the SQL Server Explorer into a dataset I am building
I get the table, fieldnames and types. But, why doesn't it put in relations,
defaults and all the other information from the SQL Server. It takes time to
do this in VS when it is already done on the SQL Server. When I build a
diagram in SQL Server all this information gets there automaticly, but not
in VS.NET. Are there som settings I am missing here? We do have some
datasets with lots of tables and relations, constraints, defaults....

Thanx all.
gh

 

[Jim Hughes]

The XSD tool that VS uses is but one way of creating typed datasets.

You may want to take a look at alternative tools like CodeSmith
http://www.ericjsmith.net/codesmith/ which uses customizable templates to
generate code like typed datasets, data access layers and business objects..