Difference between datareader and dataset?
Answer Posted / anju
- Data reader is a connection oriented architecture as its
requires continues connection with Data base.
while Data set is disconnected oriented architecture,
whenever user wants to pull the data he/she build the
connection with Data base.
-Data readers execution is very fast. as it reads only
forward stream.
while
Data set execution is slow as compare to Data reader, as it
carries bundle of data.
- when data changes requires frequently then User should go
for Data set, when user doesn't require data changes
frequently then he/ should go for Data Reader.
| Is This Answer Correct ? | 14 Yes | 6 No |
Post New Answer View All Answers
What is the purpose of using adodb?
What is ado oledb and odbc?
What is the difference between data reader and data adapter?
What are three methods for displaying data in a syncfusion datagrid
What is the full form of ado.net?
What is ado control?
What is ole used for?
What is ado or jdbc?
Explain the advantages and disadvantages of using datalist?
What is the meaning of object pooling?
What is DataReader Object?
What are the data access namespaces in .NET?
Describe the disconnected architecture of ADO.NET’s data access model.
What do you know about ADO.NET's objects and methods?
Explain what are the steps to connect to a database?