DataReader vs DataSet debate

Panmanphil wrote an article on Datareader vs Dataset debate. It worth a read. A great example given to show which control is more appropriate, Datareader or Dataset...

Consider this:

open connection
execute query
fill dataset
close connection
loop through dataset
- handle each row of data to do some operation
dispose of dataset


Compared to:

open connection
execute query
loop through reader
- handle each row of data to do some operation

close reader
close connection

[Read More...]