ADO.NET Tips

ADO.NET
            ADO.NET provides consistent access to data sources such as SQL Server and XML, and to data sources exposed through OLE DB and ODBC. Data-sharing consumer applications can use ADO.NET to connect to these data sources and retrieve, handle, and update the data that they contain.

ADO.NET 2.0 Features
  • Enhancements to the DataSet and Datatable classes. 
  • Optimized DataSet Serialization. 
  • Conversion of a DataReader to a DataSet or a DataTable and vice versa. Data Paging. 
  • Batch Updates — Reduction in database roundtrips. 
  • Asynchronous Data Access. Common Provider Model.
ADO.NET 3.5 Features

  • Expanded Entity Framework (EF 4.0 and 1.0) Support . 
  • Connection Pooling Performance Enhancements . 
  • Increased Breadth of Support.