Loading multiple tables and relationships

  • Thread starter Thread starter RichardF
  • Start date Start date
R

RichardF

I have a SQL database that contains multiple tables and various
foreign key relationships and between those tables.

The size of the database is very small (about 1 MB) but the
relationships are quite complex.

I would like to load all the tables and all the relationships into a
DataSet object so that I can do my processing without constantly
hitting SQL Server.

I know how to load the tables one at a time, but how do I load the
relationships?

Can I load all tables and relationships at one time?

Thanks for any help.

RichardF
 
Hi,

You cannot load relations directly from the database. What you need to is to
create XSD file, that describes structure and relations and then create
DataSet based on this schema and load it with the data from the database
 
Back
Top