VS2005 (ADO.NET 2.0) introduces BCP (Bulk Copy). Using streaming they have improved performance significantly for bulk uploads.
DataSet has been greatly enhanced (better scalability, incremental index updates, low overhead) in ADO.NET 2.0.
SqlDependency for Caching: Allows you to track queries and fire an event when the results change; tracks whole result sets; change notifications help in caching; no need for cache expiration policies.
SqlDependency + DataSet: middle-tier cache (cache data in DataSet, track queries and change notifications). Demo shows (with an XSD declared DataSet) that you can subscribe to changes... so your cache can be updated. Sweet.
Controlling Granularity: Becuase it takes too long to kill large datasets (before an update when SqlDependency is fired), you want to assign the SqlDependency on more granular queries(/). Demo show's this coded. Now we can just update the when the data changes from the subset queries.
DataSet enhancements enable huge caches, so we can Query Over DataSet. Basically the demo shows that the DataSet can be indexed... thus speeding up large resultsets.
Tags: [PDC05]
posted @ Thursday, September 15, 2005 11:09 AM