Update DataSet definiton from Server Explorer

  • Thread starter Thread starter TheMaxx
  • Start date Start date
T

TheMaxx

I use typed DataSet (drag'n drop from server Explorer from SQL Server 2000).
Each time i modify a table i need to update the Dataset.

I do it by deleting and adding a table again from Server Explorer. As
project got bigger, and having many tables around this has become a very
anoying task.

Is there a better (automated) way to update DataSet definition?
 
My suggestion is try to cement your schema before moving forward. If you do
not understand your data yet, you may have an issue.

This is not always possible, of course. In an environment that changes
often, I would consider using a code gen (like LLBLGen Pro, etc.) to create
business objects and/or typed DataSets. SharpToolbox has a list of code
gens.

As far as a better way for tables. You can create your own or use something
like CodeSmith (you can probably find a template already for direct table
DataSets). In 2.0, the table adapter model is easier than recreating, as
well. Scott Guthrie has a nice blog entry on this.

--
Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA

*************************************************
Think outside of the box!
*************************************************
 
Thanx for suggestions for walkarounds, but i really need specific function:
- update DataSet definition automatically from known source
 
Back
Top