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 |
What is concurrency? How will you avoid concurrency when dealing with dataset? (One user deleted one row after that another user through his dataset was trying to update same row. What will happen? How will you avoid the problem?)
Explain different methods and Properties of DataReader which you have used in your project?
How can we save all data from dataset?
What does connection string consists of ?
How many commands does the oledbcommand takes?what are they?
Do you use stored procedure in ado.net?
Explain the difference between data reader and data adapter?
What is connection string?
What is adodb dll?
Explain how can we load multiple tables in to dataset?
How to Read, Add, Update and Delete record in Entity Framework ?
Describe the command object and its method.
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)