ADO.NET is Disconnected Architecture. DataReader is
connected Architecture, but DataReader is a part of
ADO.NET. How is it possible?
Answer Posted / rangarao
Ado.net is supports disconnected architecture as well as
it also supports connected architecture.
data set belongs to disconnected architecture.
data reader belongs to connected architecture.some problems will arrive while working with data reader,the problems are it will read records one by one only and there is no possibility to go for previous record ,it will always go to next records only.the connected architecture recommended to while working with transactions and working with bulk amount of data.
| Is This Answer Correct ? | 22 Yes | 1 No |
Post New Answer View All Answers
What is the maximum pool size in ado.net connection string?
What is ado.net components?
How to read data with the sqldatareader ?
what is the difference betwen typed dataset and untyped dataset?in general which dataset can we use in programming?
What two types of data providers does ADO.NET supply? What determines which one you should use?
What are the 3 major types of connection objects in ado.net?
What are the namespaces used in ADO.Net to connect to a database?
What are the steps you will take to improve performance? Will you use dataset or datareader?
Explain why canot we use multiple inheritance and garbage collector paralelly in .net?
What is data control techniques?
What is executenonquery ado.net?
What is the procedure to call a Stored Procedure of Back End in ADO (ActiveX Data Object) and RDO (Remote Data Objects)?
Explain what is datagrid with an example?
What is a sqldataadapter?
What is the use of SqlCommandBuilder?