ADO.NET is Disconnected Architecture. DataReader is
connected Architecture, but DataReader is a part of
ADO.NET. How is it possible?
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / arun
ADO.NET is not a disconnected architecture.
The dataset is a disconnected architecture and the
datareader is a connected architecture.
| Is This Answer Correct ? | 26 Yes | 6 No |
Answer / debakant mohanty.
ADO .net is a disconnected arcitecture and data reader is a
connected architecture.It is possible because the data is
retreived from the database when there is a connection
established and is a stored in a temporary storege area
called data set and are retrieved from there by data
reader.That is simple.
| Is This Answer Correct ? | 3 Yes | 9 No |
How to load multiple tables into a dataset?
How is it possible to get 2 tables of data at a time by using data reader?
What is an ado?
What is serialization and de-serialization in .net? How can we serialize the dataset object?
What is difference between executenonquery and executequery?
What is the default timeout specified for "sqlcommand.commandtimeout" property?
What is ado control?
What is the difference between connected and disconnected environment?
What is sqldatasource?
How do we invoke queries from the application ?
Difference between function and trigger?
What is datatable in ado.net?
Visual Basic (800)
C Sharp (3816)
ASP.NET (3180)
VB.NET (461)
COM+ (79)
ADO.NET (717)
IIS (369)
MTS (11)
Crystal Reports (81)
BizTalk (89)
Dot Net (2435)
Exchange Server (362)
SharePoint (720)
WCF (340)
MS Office Microsoft (6963)
LINQ Language-Integrated Query (317)
WPF (371)
TypeScript (144)
Microsoft Related AllOther (311)