Subscribe

RSS Feed (xml)

Powered By

Skin Design:
Free Blogger Skins

Powered by Blogger

Search Your Question

Monday, May 5, 2008

Can you explain major differences between an ADO.NET Dataset and an ADO Recordset?

1) A DataSet can represent an entire relational database in memory, complete with tables, relations, and views.
2) A DataSet is designed to work without any continuing connection to the original data source.
3) Data in a DataSet is bulk-loaded, rather than being loaded on demand.
4) There's no concept of cursor types in a DataSet.
5) DataSets have no current record pointer You can use For Each loops to move through the data.
6) You can store many edits in a DataSet, and write them to the original data source in a single operation.
7) Though the DataSet is universal, other objects in ADO.NET come in different versions for different data sources.

No comments:

Archives