.NET C C++ CSS DBA General HTML Java JavaScript JSP JUnit MySQL Networking Oracle Perl Perl PHP PL/SQL RSS Software QA SQL Server Struts Unix Windows XHTML XML

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

Q

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

✍: Guest

A

There two main basic differences between recordset and dataset
? With dataset you an retrieve data from two databases like oracle and sql server and merge them in one dataset , with recordset this is not possible
? All representation of Dataset is using XML while recordset uses COM.
? Recordset can not be transmitted on HTTP while Dataset can be.

2007-10-24, 4784👍, 0💬

.NET C C++ CSS DBA General HTML Java JavaScript JSP JUnit MySQL Networking Oracle Perl Perl PHP PL/SQL RSS Software QA SQL Server Struts Unix Windows XHTML XML