ADO .NET
These topics provides students with the knowledge to develop data-access applications by using the Microsoft .NET Framework and Microsoft Visual Studio 2005. Further it provides skills needed needed to use advanced data access features and techniques in the Microsoft .NET Framework and Microsoft Visual Studio 2005.
The workshop describes how to access and update data in a database by using ADO.NET and how to implement database functionality by using Microsoft ADO.NET 2.0 and Microsoft SQL Server 2005.
The workshop also describes how to create, read, and write XML data as well as how to locate, edit, and transform XML by using XPath and Extensible Style sheet Language for Transformations (XSLT).
Audience
This workshop is intended for corporate and Independent Software Vendor (ISV) application developers who have a desire to learn more about specific technology areas in distributed application development.
Objectives
- 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.
Details
- Overview
- Using Commands and ADO.NET Commands
- Performing Transactional Operations
- Local and Distributed Transactions
- Disconnected Operations with DataSets and DataViews?
- Performing Disconnected Operations by Using Visual Studio 2005 Wizards
- Disconnected Data, DataSets and DiffGrams?
- Reading and Writing XML Data
- Processing XML Data by Using DOM
- Minimizing and Handling Database Operation Conflicts
- Handling Large Objects
- Enhancing Database Performance with ADO .NET 2.0
- Creating Managed Code Objects for SQL Server 2005
- Querying XML by Using XPath
- Transforming XML by Using XSLT Style Sheets
Prerequisites
Be able to program an application using a .NET Framework 2.0 compliant language and have a good understanding of basic relational database concepts
|