What is difference between Dataset.Clone and Dataset.Copy?
Clone: - It only copies structure, does not copy data.
Copy: - Copies both structure and data.
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 can 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.
See following video on Dataset is a disconnect while datareader is connected: -
Click and see here for more
training on ADO.NET.