Loading multiple tables and relationships

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
 
V

Val Mazur \(MVP\)

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Dataset - Relations vb 2005 3
linking tables and relationships 3
Programmitically accessing table relationships/constraints 1
Wanted: Good LINQ tutorial 4
Look up tables vs. relationships design 1
running multiple scripts 3
Disappeared Relationships; Can't Recreate 2
Where should relationships be created? 8

Top