DataReader with DataSet

Question

Hi Define relationship between DataReader and DataSet?

Hemant Kumar · Answer

Just check out this article. http://www.dotnetspider.com/qa/Question1306.aspx Hope it helps.

Vilas Gite · Answer

Hi Rajesh.. Refer: Our Recommended Articles… http://www.c-sharpcorner.com/UploadFile/61b832/4102/ Thanks! ---------------------------------------------------------------------- If this reply helps your post…then check  This is correct answer

Prabhu Raja · Answer

Hi Rajesh DataSet The dataset is a disconnected in-memory representation of data. It can be considered as a local copy of the relevant portions of the database. The DataSet is persisted in memory and the data in it can be manipulated and updated independent of the database. When the use of this DataSet is finished changes can be made back to the central database for updating. The data in DataSet can be loaded from any valid data source like Microsoft SQL server database an Oracle database or from a Microsoft Access database. The DataReader Object The DataReader object provides a forward-only read-only connected stream recordset from a database. Unlike other components of the Data Provider DataReader objects cannot be directly instantiated. Rather the DataReader is returned as the result of the Command object's ExecuteReader method. The SqlCommand.ExecuteReader method returns a SqlDataReader object and the OleDbCommand.ExecuteReader method returns an OleDbDataReader object. The DataReader can provide rows of data directly to application logic when you do not need to keep the data cached in memory. Because only one row is in memory at a time the DataReader provides the lowest overhead in terms of system performance but requires the exclusive use of an open Connection object for the lifetime of the DataReader. For more Reference : use MSDN Documentation in ADO.Net Thank You

Satyapriya Nayak · Answer

Hi Rajesh DataReader represents only one database record at a time. You must call the Read() method to fetch each new record from the underlying database table into memory. Each time you call Read() again the previously fetched record is lost. DataSet is on the other hand enables you to represent the results of a database query in your server's memory. Because a DataSet provides you with a memory-resident representation of data you can work with the results of a database query as a whole. DataReader must remain connected to a database table. A DataReader is tied down to its underlying data source. The DataSet object is central to supporting disconnected and distributed data scenarios with ADO.NET. The DataSet is a memory-resident representation of data that provides a consistent relational programming model regardless of the data source. It might be helpful to think of a DataReader as a forward-only recordset. A DataSet on the other hand is similar to a disconnected client-side static recordset. DataSets also require more overhead to create and populate than DataReaders. Thanks