ADO.NET 2.0 Advance Features
-
New Indexing Engine
-
DataSet Remoting (Serialization>> Binary & Xml)
-
DataReader Trasfer (directly into DataSet or DataTable)
-
DataPaging (only with SqlClient)
-
Batch Update (only with SqlDataAdapter & DBDataAdapter )
-
SqlBulkCopy (moving data from one Datasource to another another)
-
MARS (Multiple Active Resultset)
-
Asynchronous command
-
Connection Pooling (enchancement)
-
DataView.ToTable()
-
Provider Statistics
-
Common Provider
-
Transactions
-
DataPaging (only with SqlClient)