The workshop describes how to access data and how to implement database functionality by using Microsoft ADO.NET 2.0 and Microsoft SQL Server 2005. The workshop also describes how to locate, edit, and transform XML by using XPath and Extensible Style sheet Language for Transformations (XSLT). After completing this workshop, you will be able to: - Connect to databases and read data. - Query and update databases by using commands. - Perform transactional operations. - Perform disconnected operations programmatically. - Perform disconnected operations by using Visual Studio 2005 wizards. - Perform XML operations on disconnected data. - Read and write XML data. - Process XML data by using the Document Object Model DOM. - Minimize and handle database operation conflicts. - Handle large objects. - Enhance database performance. - Create managed code objects for SQL Server 2005. - Query XML by using XPath. - Transform XML by using XSLT style sheets.