ADO.NET 2.0 and SQL Server 2005 share a great deal of functionality and complementary technologies. This chapter concentrates on three core areas of functionality: Multiple Active Results Sets (MARS), SQL Server Query Notifications, and SQL Server user-defined types (UDTs).
More info