Mar 2, 2010

Can you explain the difference between an ADO.NET Dataset and an ADO Recordset?

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






Record set for a single tale
Data set for multiple tables ,supports xml,and connection less



Dataaset can Store whole of your database with relationship also
But Recorset can just store table
 

No comments:

Post a Comment