Can you explain the difference between an ADO.NET Dataset
and an ADO Recordset?
Answers were Sorted based on User's Feedback
Answer / ganesh
Valid answers are:
· A DataSet can represent an entire relational database in
memory, complete with tables, relations, and views.
· A DataSet is designed to work without any continuing
connection to the original data source.
· Data in a DataSet is bulk-loaded, rather than being
loaded on demand.
· There's no concept of cursor types in a DataSet.
· DataSets have no current record pointer You can use For
Each loops to move through the data.
· You can store many edits in a DataSet, and write them to
the original data source in a single operation.
· Though the DataSet is universal, other objects in ADO.NET
come in different versions for different data sources.
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / siddarth
dataset is nothing but in memory database for client
application.
Dataset supports bidirectional navigation and it supports
purely disconnected architecture with xml integration.
it supports plat form independency.
The above are all not supported by recordset.
| Is This Answer Correct ? | 0 Yes | 0 No |
Difference between Dataset and DataReader ?
4 Answers Accenture, BirlaSoft, Infosys, Microsoft, Techseol,
Explain the various authentication mechanisms in asp.net.
which is better arraylist or dictionary?
How do you declare delegates and are delegates and events one and the same and explain how do you declare delegates and invoke them ?
What is applicatio domain?
What are the event handlers that we can have in global.asax file?
Define the term Web Garden?
0 Answers Sans Pareil IT Services,
What is an iHTTPModule, and explain its implementation with its limitations?
What is the most appropriate lifetime for a database connection/orm context in an asp.net mvc application? : Asp.Net MVC
What are three ways that you can use a compare validator?
What is asp net_sessionid?
How many classes can a single .NET DLL contain?
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)