Namit

• Nov 2nd, 2006

 

ActiveX Data Objects (ADO) is a COM-based class library for interacting with data sources. It offers optimized access over the Internet and intranets.ADO.NET 1.0 surpasses ADO in its ability to work with various data sources. It provides a richer set of objects for various types of applications for both client/server and multitier environments. ADO.NET 2.0, the latest version, provides better platform interoperability and scalable data access from connected and disconnected sources.

samridhi

• Jun 25th, 2007

 

1. Ado.net 2.0 provides MARS ( multiple active resultsets which allows you to have two datareader on one connection open at sametime.
2. Ado.net 2.0 provide bulk copy facility.
3. Ado.net 2.0 provides table adapters and hence allows easy to create DAL.

There must be many other benifits of using ado.net 2.0 but i know this many only.