Advantage of data set

  • Thread starter Thread starter Steffen Loringer
  • Start date Start date
S

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
 
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.
 
Back
Top