How many .xsd datasets for a site?

[H5N1]

Hi there
Is it OK to use one big xsd dataset (using Table Adapter Wizard) for
whole site, and just to include there all tables used on each page, or
should I keep those datasets as small as possible (for example if on
each update the whole dataset must be updated, and not only specific
tables).
What's the practice?

thanks

[sloan]

I would vote a strong NO to the uber DataSet..

The datasets should be big enough to handle the smaller business take at
hand.

If I need Customer, Orders and OrderDetail info, then make a DS with 3
tables (using Northwind as an example)

You also will have maintenance issues, because different
developers...different business problems will make alterations, breaking
someone else's usage.

a dataset should represent the "smaller world" parts of your overall
database...

"H5N1" <ha****@gmail.com> wrote in message
news:11**********************@g10g2000cwb.googlegr oups.com...

Hi there
Is it OK to use one big xsd dataset (using Table Adapter Wizard) for
whole site, and just to include there all tables used on each page, or
should I keep those datasets as small as possible (for example if on
each update the whole dataset must be updated, and not only specific
tables).
What's the practice?

thanks