07 July 2014

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.
  • Bulk Copy.

*******************************************************************************
ADO.NET 3.5 Features:

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

*******************************************************************************

No comments: