DataSet

[Douglas Buchanan]

Is it a valid DataSet which contains multiple tables with no
relationsips between them?

Should I anticipte any problems working with such a dataset.

Situation:
I have very many tables within a form called settings which is used
manages settings for a database application. I don't need
relationships in this form but do need access to all the tables for
the administrator to do the management. It is much more convenient to
group them in logical datasets and access them via a combobox.

 

[Cole]

Relations are not required in a DataSet. You should have no problem.

Cole

 

[Sahil Malik]

A dataset is a mini RDBMS in memory. You are not required to fill relations.
SqlDataAdapter.Fill will not move the relation information from d/b to the
dataset.

- Sahil Malik
You can reach me thru my blog at
http://www.dotnetjunkies.com/weblog/sahilmalik

 

[Guest]

Hi Douglas,

DataRelations are not necessary while creating a dataset, and working with a
dataset with no relations will not cause you problems.

But datasets with relations will have a benefit. A dataset with relations
will probably mirror the structure of your DB including the relations set
there. Hence, most of the inconsistancy/relation issues that can happen with
invalid data can be sorted out @ the client side itself, without a trip to
the db server.

HTH,
Rakesh Rajan