www.asp.net website introduced a way to develop 3-tier websites (
http://www.asp.net/learn/dataaccess/....aspx?tabid=63 )

The question is, how to modify datasets without deleting and creating
datatables?

Let's imagine we've a table in SQL Server named "Person",
it includes: ID,FirstName,LastName fields.

we create a dataset in App_Code folder, and configure it to show Person
table and generate Insert,Update and Delete code by its wizard.

Then we write methods in BLL to show/add/modify records of Person table.

Well, imagine we had a bad design and now we decide to add Telephone field
to Person table,
what is the best way to update dataset and re-write BLL methods?

Deleting the dataset and re-creating it is a bad idea, because we may have
many queries in the table adapter attached to dataset.

Sometimes (alot of times?) RAPID development is not the same as GOOD
DEVELOPMENT.

Try here:
http://sholliday.spaces.live.com/blog/
5/24/2006
Custom Objects/Collections and Tiered Development

on how to build a maintainable DataSets (and how to populate them)...


There's a 2.0 version also .... june 2006.





"Saber S." <Saber S.@discussions.microsoft.com> wrote in message
news:B7D5477A-6E5E-4D1A-98C2-(E-Mail Removed)...
> www.asp.net website introduced a way to develop 3-tier websites (
> http://www.asp.net/learn/dataaccess/....aspx?tabid=63 )
>
> The question is, how to modify datasets without deleting and creating
> datatables?
>
> Let's imagine we've a table in SQL Server named "Person",
> it includes: ID,FirstName,LastName fields.
>
> we create a dataset in App_Code folder, and configure it to show Person
> table and generate Insert,Update and Delete code by its wizard.
>
> Then we write methods in BLL to show/add/modify records of Person table.
>
> Well, imagine we had a bad design and now we decide to add Telephone field
> to Person table,
> what is the best way to update dataset and re-write BLL methods?
>
> Deleting the dataset and re-creating it is a bad idea, because we may have
> many queries in the table adapter attached to dataset.

Thanks solan,
I downloaded the sample project (
http://www.reasolns.com/codeSamples/...erExample1.zip )

In this project, there is no dataset, but there are classes made of tables,
The datasets can be create dynamically using SQLHelper, but what about typed
datasets?
the

"sloan" wrote:

>
> Sometimes (alot of times?) RAPID development is not the same as GOOD
> DEVELOPMENT.
>
> Try here:
> http://sholliday.spaces.live.com/blog/
> 5/24/2006
> Custom Objects/Collections and Tiered Development
>
> on how to build a maintainable DataSets (and how to populate them)...
>
>
> There's a 2.0 version also .... june 2006.
>
>
>
>
>
> "Saber S." <Saber S.@discussions.microsoft.com> wrote in message
> news:B7D5477A-6E5E-4D1A-98C2-(E-Mail Removed)...
> > www.asp.net website introduced a way to develop 3-tier websites (
> > http://www.asp.net/learn/dataaccess/....aspx?tabid=63 )
> >
> > The question is, how to modify datasets without deleting and creating
> > datatables?
> >
> > Let's imagine we've a table in SQL Server named "Person",
> > it includes: ID,FirstName,LastName fields.
> >
> > we create a dataset in App_Code folder, and configure it to show Person
> > table and generate Insert,Update and Delete code by its wizard.
> >
> > Then we write methods in BLL to show/add/modify records of Person table.
> >
> > Well, imagine we had a bad design and now we decide to add Telephone field
> > to Person table,
> > what is the best way to update dataset and re-write BLL methods?
> >
> > Deleting the dataset and re-creating it is a bad idea, because we may have
> > many queries in the table adapter attached to dataset.
>
>
>

On Jan 31, 8:03 am, Saber S. <Sab...@discussions.microsoft.com> wrote:
> Thanks solan,
[snip]

I totally agree with Sloan, DataSets are probably the biggest anti-
design pattern ever implemented since Visual Basic was created...

STAY AWAY from DataSets!
Use some ORM tool instead...

..t

--
http://ajaxwidgets.com
Free ASP.NET Ajax Widgets NOW!