Advantage of data set

[Steffen Loringer]

Hi group,

can somebody tell me what the big advantage of a dataset is? Is ADO.NET
the same? Why should I not access the SQL Server directly??

Thanks
Steffen

 

[Steve C. Orr [MVP, MCSD]]

Datasets are disconnected from the datasource, so you can hold it in memory
and do whatever you want with the data without it affecting database
performance at all.
The Dataset class has lots of useful functionality.
Datasets can be easily cached & serialized.
If you just need to spit out some data real quick and not do anything fancy
with it then you might prefer to use a DataReader which stays directly
connected to SQL Server while it is open.