difference between data reader and dataset



difference between data reader and dataset..

Answer / Narayan Singh Parihar

DataReader and Dataset are both ADO.NET components used for data access in .NET, but they have some differences.nn- Dataset: A DataSet is an in-memory cache of data that can hold multiple tables, relations, and views. It provides a disconnected architecture, meaning the data doesn't need to remain connected to the database while being processed.nn- DataReader: Unlike DataSet, a DataReader is a forward-only, read-only stream of data that maintains a live connection with the data source during execution. It is typically used for scenarios where reading large amounts of data is required and memory usage needs to be minimized.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Dot Net AllOther Interview Questions

what does dot in .net means

1 Answers  


How Web service create Proxy Using WSDL?

1 Answers  


So what exactly is the configuration file for then?

1 Answers  


How to improve the cache performance? : Dot net architecture

1 Answers  


What is the access level of the visibility type internal?

1 Answers  


What is application frame host?

1 Answers  


What exactly is being serialized when you perform serialization? scope in C# ?

1 Answers  


Write a query Where,Groupby,having clauses?

2 Answers   iGate,


any one can explain about projectarchitecture and project approach briefly

1 Answers  


what is a required field validation control?

2 Answers   Six Sigma,


How do you handle this COM components developed in other programming languages in .NET?

1 Answers   InfoAxon Technologies,


What is .net transaction?

1 Answers  


Categories