Diff. b/w DataReader and DataSet?
Answer Posted / tejas mer
DataReader is connected architecture and it's read-only, forward only type, so when you just want to display the data better to use it, it consumes less memory with compare to dataset as well.
DataSet is we can say in-memory representation of the data.
It's disconnected architecture.
Contains DataTables, which are further divided into Datarows and Datacolumns.
Also contains DataRelationships and Contraints...
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
Which namespaces are used for data access?
What is untyped dataset?
What is data view and variable view?
What is sqldatareader?
What is ado oledb and odbc?
What is a sqldataadapter?
What is Data view?
What is the default Timeout for SqlCommand.CommandTimeout property?
What are the benefits of ADO.NET?
What is ole db and odbc?
Which is better entity framework or ado.net?
What is the DataTableCollection?
Command objects uses, purposes and their methods.
What is two way data binding android?
Explain the DataAdapter.Update() and DataSetAcceptChanges() methods.