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.