Difference between datareader and dataset?
Answer Posted / sumanth
Data Reader:A class used to efficiently process a large list
of results one record at a time.
Data Set:A Data Set object represents a schema (either an
entire database or a subset of one). It can contain tables
and relationships between those tables.
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
Explain how do you connect to sql server database without using sqlclient?
What are the different namespaces used in the project to connect the database? What data providers available in .net to connect to database?
What is the difference between DataReader and DataSet in ADO.NET?
What is ole in excel?
Does ado.net use odbc?
How can we load multiple tables in to dataset?
What is execute scalar in ado.net?
What are the parameters that control most of connection pooling behaviors?
How to store data in memory?
What is the procedure to call a Stored Procedure of Back End in ADO (ActiveX Data Object) and RDO (Remote Data Objects)?
Define atomicity?
What is the difference between Response.Expires and Reponse.ExpiresAbsolute?
What is disconnected scenario in entity framework?
Explain the difference between an ado.net dataset and an ado recordset?
Explain About ado.net components/objects. Usage of data adapters and tell the steps to retrieve data.