adspace


difference between data reader and dataset

Answer Posted / 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       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain element .net mobile with example? : Microsoft dot net mobile

1064


hi, kindly send WWF(.net 3.5) pdf notes to my id. thanx in advance, chays

2411


How do I know when my thread pool work item has completed?

1011


I can't be bothered with cas. Can I turn it off?

1024


How does an appdomain get created?

1040


difference between Response.write,server.transfer and also which one is used when ?

1988


Different types of authentication modes in .net framework ?

1071


Why am I getting an invalidoperationexception when I serialize an arraylist?

982