«

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

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" <> wrote in message
news: 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
>