Can you explain the difference between an ADO.NET Dataset
and an ADO Recordset?

Answers were Sorted based on User's Feedback



Can you explain the difference between an ADO.NET Dataset and an ADO Recordset?..

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

Can you explain the difference between an ADO.NET Dataset and an ADO Recordset?..

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

Post New Answer

More ASP.NET Interview Questions

what is uncle aunty file

1 Answers  


What is asp.net mvc5? : Asp.Net MVC

0 Answers  


What is a viewstate?

0 Answers  


hi ans dis qstn. "what is d max size of query string. If it exceeds does it give error. if yes wt error it gvs, if no gv the reason" thnx in advance

3 Answers  


main difference between asp.net2.0,asp.net1.1,asp.net1.0

1 Answers   Northgate is,






Can you change a master page dynamically at runtime? How?

0 Answers  


Is It Possible for Static Variables access normal variable? and Normal Varialbe Access the static Variables?

1 Answers   Phoenix Technologies,


In asp.net, how can you validate drop down box?

0 Answers   Accenture,


How to retrieve user name in case of Window Authentication?

0 Answers  


What is global.asax file used for?

0 Answers  


Can you explain one critical mapping?

0 Answers  


How do u declare static variable and how it is declared and what is its lifetime?

0 Answers  


Categories