Skip to main content

Difference between DataSet and DataReader

Data Reader
i) Data Reader is readonly so we can't do any transaction on them.
ii) Data Reader will be the best choice where we need to show the data to the user which requires no transaction.
iii) Data Reader is like a forward only recordset. It fetches one row at a time so very less network cost compare to DataSet(Fethces all the rows at a time). As DataReader is forward only so we can't fetch data randomly.
iv) .NET Data Providers optimizes the datareader to handle huge amount of data.

DataSet
i) DataSet is an in memory representation of a collection of Database objects including tables of a relational database schemas.
ii) DataSet is always a bulky object that requires a lot of memory space compare to DataReader.
iii) DataSet fetches all data from the datasource at a time to its memory area. So we can traverse through the object to get the required data like querying database.
iv) DataSet can have relationship between the fetched tables.

If you feel this tips help you then leave a comment...................

Comments

Popular posts from this blog

Large Volume of Dataset Transfer from WCF to Silverlight

Most of the times the developers, architects have the problem to retrieve large volume of data from WCF Service to Silverlight client applications. It’s a big head ache for developers. But it’s not up to that much problematic one. We can solve this problem by changing some property’s values in Web.config of WCF Service host, Silverlight application’s ServiceReference.clientconfig and Silverlight XAP hosted ASP.Net Applications. Here I’m going to explain the Web.config changes we need to retrieve large volume of data from WCF Service and also uploading large size of files to the Server. Last week, I was trying to figure out why my WCF service call always threw the generic NotFound exception when trying to retrieve large datasets. Even though, I set buffer limits to 2147483647 (int.MaxValue) in the Silverlight ServiceReferences.ClientConfig file and WCF Service configuration Section under web.config the problem was persisting. I tried so many things from Data Access Layer and UI. Finall...

Multiplication Table in SQL Server

Multiplication Table in SQL Server This query gives the multiplication table from 1 to 10. DECLARE @A INT,                   @B INT,                   @C INT,                   @D VARCHAR (100)                   SELECT @A=1                  PRINT ' MULTIPLICATION TABLE 1-10' /****************************************/ /* Created By : Loganathan V */ /* Created On: 20-Sep-2010, Monday */ /* Purpose : Multiplication Table */ /* How to : RUN THE QUERY */ /****************************************/ WHILE (@A<=10) BEGIN         ...

The React Cookbook Advanced Recipes to Level Up Your Next React App