ADO.NET 2.0 Feature Matrix

A must read article about ADO.NET 2.0 Feature Matrix, top 9 features are:

ADO.NET 2.0 does not use the Microsoft Data Access Components (MDAC).
You can clear a connection pool by using the static method SqlConnection.ClearPool.
Built-in SqlCommand methods that provide asynchronous execution.
And finally SqlClient contains a new class called SqlBulkCopy, for inserting many rows into the database from a client in one round-trip

MARS - multiple active result sets .
SqlDependency - Registering for notifications for DB changes.
Promotable transactions - the new System.Transactions namespace, enabling a behavior that can automatically detect multi-instance access and "promote" a transaction from local to multi-instance (distributed).
"hot spare" capability through database mirroring. If a SQL Server instance fails, the work can be shifted over to the backup server automatically.
And of course support for user-defined types and native XML data type and better large data support

Posted: Nov 19 2004, 07:52 PM by lrozner | with 2 comment(s)

Comments

# November 19, 2004 7:02 AM

First Point about ADO.Net not requireing MDAC is not true. Read Microsoft KB315467

# February 14, 2008 6:22 AM