h1.post-title { color:orange; font-family:verdana,Arial; font-weight:bold; padding-bottom:5px; text-shadow:#64665b 0px 1px 1px; font-size:32px; } -->

Pages

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.