ADO.Net DataSet can replace ADO RecordSet. The Record Set can contain on one table value while the dataset can contain multiple tables values.
ADO.NET object DataSet Good one the main reasons are,1. .net DataSet is Disconnected architecture while ADO Recordset is Connected. 2. We can easily return datarecords using DataSet but as far as i know it is not possible with recordset
dataset
The entire ADO.NET thing is actually the new ADO for .NET.
ADO.NET dataset is good replacement
There are alot...but the base once are SqlConnection, OleDbConnection, etc...