Difference Between ADO and ADO.NET 
Author Message
 Difference Between ADO and ADO.NET
Dear Sir/Madam,
              Please give me the solution for the following
 1. The difference between ADO and ADO.NET
 2. Difference Between a Recordset in JAVA and dot NET
 3. When to use DataReader and DataSet.


Mon, 07 Nov 2005 23:28:23 GMT
 Difference Between ADO and ADO.NET

These are VERY broad questions not really suitable for answer in a newsgroup
but here is the 20,000 foot view:

1. ADO (COM-based) "classic" is a programming interface to OLE DB. ADO.NET
is a .NET Framework namespace consisting of classes and infrastructure
designed to interface to .NET Framework Data Providers which include SQL
Server (SqlClient), Oracle, ODBC and OLE DB.

2. I've never used JAVA, and probably never will so I'll pass on #2.

3. The DataReader is a low-level IO stream used by .NET data providers. It
returns rowsets as a data stream. The DataSet is a container (of sorts) that
manages one or more DataTables. ADO.NET uses the DataAdapter and the
DataReader to populate a DataSet.

--
____________________________________
Bill Vaughn
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________


Quote:
> Dear Sir/Madam,
>               Please give me the solution for the following
>  1. The difference between ADO and ADO.NET
>  2. Difference Between a Recordset in JAVA and dot NET
>  3. When to use DataReader and DataSet.



Tue, 08 Nov 2005 00:32:46 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. is there difference between ado+ and ado.net?

2. ADO.NET Component and VB6 client - ADO.Net or ADO 2.7

3. ADO ADO ADO ADO ADO VB examples / samples book wanted

4. Version difference from ADO 2.5 to ADO 2.7

5. Pass ADO/ADO.NET parameter arrays for batch insert/update

6. xpath ado vs ado.net properties

7. ADO vs ADO.NET

8. Which is more quickly ADO or ADO.NET

9. Retrieving data from Exchange 2000 server using ado/ado.net

10. Providers: ADO vs ADO.NET

11. ADO Vs ADO.NET

12. ADO.NET vs. ADO 2.7


 
Powered by phpBB® Forum Software