ADO.NET new Features in SQL Server 2005

The new features of ADO.NET are:

1. Query change notifications

2. multiple active result sets

3. Native type support

4. Notification support for SQL Server queries.

The above features make for greater flexibility and scalability and commands can now be sent to the SQL Server to request that a notification be generated if the result set is at variance with the original result set procduced.

The notifications are delivered through an asynchronous SQL Service Broker Queue and are useful for enabling the caching results in applications.