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)

Leave a Reply