ADO.NET 2.0 Feature Matrix
A must read article about ADO.NET 2.0 Feature Matrix, top 9 features are:
-
ADO.NET:
-
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
-
SQL Server 200:
-
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