Difference between dataset and datareader.

Difference between dataset and datareader.

Dataset:

- DataSet object can contain multiple rowsets from the same data source as well as from the relationships between them.
- Dataset is a disconnected architecture
- Dataset can persist data.

Datareader:

- DataReader provides forward-only and read-only access to data.
- Datareader is connected architecture
- Datareader can not persist data.

Difference between dataset and datareader.

Dataset:

1. Disconnected.
2. Can traverse data in any order front, back.
3. Data can be manipulated within the dataset.
4. More expensive than datareader as it stores multiple rows at the same time.

Datareader:

1. Connection needs to be maintained all the time.
2. Can traverse only forward.
3. It is read only therefore, data cannot be manipulated.
4. It is less costly because it stores one row at a time.
.NET Mobile overview
.NET Mobile overview - .NET Mobile is a platform for developing applications for mobile phones. It’s an extension to .NET Framework and is called Microsoft Mobile Internet Toolkit.......
Pros and cons of LINQ (Language-Integrated Query)
Pros and cons of LINQ - Stored procedures normally are faster as they have a predictable execution plan. Therefore, if a stored procedure is being executed for the second time......
Disadvantages of LINQ over Stored Procedures
Disadvantages of LINQ over Stored Procedures - LINQ needs to process the complete query, which might have a performance impact in case of complex queries against stored procedures which only need serialize sproc-name and argument data over the network.......
Post your comment