ADO Basics


 * Asynchronous Queries
 * Begin and End calls
 * Batch Updates
 * Executing multiple statements within a GO wrapper (batch) from ADO. (Originally did one statement per batch)
 * Datatable enhancements
 * Can now populate a datatable from a datareader without the overhead of a dataset and dataadaptor.
 * Bulk Copy
 * Moving lots of data from one place to another from ADO. (Use Integration Services (DTS) for complex stuff)
 * MARS (Multiple Active Result Sets)
 * Processing multiple readers off the same connection
 * DataSet Serialization
 * Better data compression which enhances data transfer (remoting). ADO previously only serialized datasets into XML.
 * myDataSet.RemotingFormat = SerializationFormat.Binary (or XML, the default)
 * Provider Factories
 * Enhanced ability to write database independent code.
 * Invariants
 * Factory provides the appropriate connection class
 * 3rd Party Libraries
 * Hibernate (NHibernate)
 * www.hibernate.org
 * Handles data access while allowing you to code in OO as pleased. Database independence.