Answer / skmdali786

Similar to the DataSet, a Recordset could be disconnected from
its data store and therefore act as an in-memory cache of
data. Of course, it could also be used in a connected model
depending on the cursor options that were set. Although the
Recordset object stored multiple versions of each column for
each of its rows, it was not by nature able to represent
multiple tables without the use of the Data Shape Provider.
The Recordset was not XML-based and could not be serialized to
XML easily or flexibly. Finally, a Recordset was not
independent of a data store because it tracked a Connection
object and through its methods could send queries to the data
source to populate, update, and refresh its data. To that end,
the Recordset contained functionality found in the ADO.NET
DataSet, data reader, and data adapter objects.

Answer / guest

1) With Data set you can retrive data from database like
oracle and SQL Server and manage them in one dataset, with
recordset this is not possible.

2) All representation of Dataset is using XML while
recordset uses COM.

Using Ado.net, what front ends and back ends can you use?

10 Answers  

---

Explain why canot we use multiple inheritance and garbage collector paralelly in .net?

0 Answers  

---

What are the ADO.NET Controls?

6 Answers  

---

Why DataReader is Forward Only?

16 Answers   IBM, NIIT,

---

What is the significance of CommandBehavior.CloseConnection ?

0 Answers   NA,

---

---

Explain the architecture of ado.net?

0 Answers  

---

Which one of the following objects is a high-level abstraction of the connection and command objects in ado.net?

0 Answers  

---

What is the difference between oledb sql server and oledbdotnet provider?

0 Answers  

---

I loaded the dataset with a table of 10 records. One of the records is deleted from the backend, How do you check whether all the 10 records were present while updating the data(Which event and steps) and throw the exception.

2 Answers   Fulcrum Logic, Satyam,

---

What is a database provider?

2 Answers   BioSys,

---

What are the advantages and disadvantages of using datalist?

0 Answers  

---

Differnces between oracle 9i and sql server?

2 Answers   College School Exams Tests, Microsoft,

---