How many .xsd datasets for a site?

  • Thread starter Thread starter H5N1
  • Start date Start date
H

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
 
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...
 
Back
Top