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

There two main basic differences between record set and dataset: -

• With dataset you an retrieve data from two databases like oracle and sql server and merge them in one dataset , with record set this is not possible.

• All representation of Dataset is using XML while record set uses COM.

• Record set cannot be transmitted on HTTP while Dataset can be.