Programming with Microsoft ADO.NET

Aims and Objectives
Describe data-centric applications, ADO.NET architecture and ADO.NET and XML.
Connect to SQL Server and other data sources.
Perform connected database operations including executing SELECT commands, database definition commands, dynamic SQL commands and commands that return data from a SQL Server database in XML.
Build a DataSet schema, populate it with data and modify the data programmatically.
Build a DataSet from an existing data source.
Use XML techniques while working with DataSets, including mapping tables and columns, creating XSD schemas, building strongly typed DataSets and interacting with XML DataDocuments.
Build a Web Service that uses ADO.NET.
Troubleshoot errors within an ADO.NET application.

Target Audiences
This course is designed for experienced application developers.

Prerequisites
Delegates should understand database basics including table, row, column, primary keys, foreign keys constraints views); concepts including SELECT
INS, UPD, DEL from tables; exposure to XML documents, stylesheets and schema; Visual Basic.NET, Visual Basic for applications or previous version of Visual Basic; describe distributed application architecture; building UI - Web applications or Windows applications.

Course Content
Module 1: DATA-CENTRIC APPLICATIONS AND ADO.NET
Module 2: CONNECTING TO DATA SOURCES
Module 3: PERFORMING CONNECTED DATABASE OPERATIONS
Module 4: BUILDING DATASETS
Module 5: READING AND WRITING XML WITH ADO.NET
Module 6: BUILDING DATASETS FROM EXISTING DATA SOURCES
Module 7: BUILDING AND CONSUMING A WEB SERVICE THAT USES ADO.NET