Why use disconnected datasets?

[Guest]

Ok, the reasons I see for using them are:
1: Database portability
2: Improved Performance on Database server as it has less work to do

The disadvantages...
1: Uncessarily comlicated to handle updates back to the database

If I am not concerned about database portability and the load on the
database server is small then would it be good practice to use datareaders
only in my asp.net application and update back to the database by stored
procedure. It seems so more easier....

 

[Karl Seguin [MVP]]

Yes.

 

[Mark Rae]

If I am not concerned about database portability and the load on the
database server is small then would it be good practice to use datareaders
only in my asp.net application and update back to the database by stored
procedure. It seems so more easier....

Yes, apart from in certain circumstances.

One of these is if you have a DataGrid, or GridView these days, bound to a
DataReader, you will not be able to do paging properly - you will ned to
bind it to a DataSet instead.

 

[Guest]

thanks for the replies, good point about the paging.

 

[Karl Seguin [MVP]]

Except it's hard to believe that in a solid app you'd actually want to page
in the presentation layer. Paging should be done at the data layer because
(a) it increases reuse and (b) is far more efficient (not a
micro-optimization).

Karl