2389 - Programming with ADO.NET

Valor:


Conteúdo Programático
E-learning Oficial Microsoft: 2389: Programming with Microsoft® ADO.NET

Curso online falado em inglês

This course teaches developers to build data-centric applications and Web services with Microsoft® ADO.NET, Microsoft SQL Server 2000, and the Microsoft .NET Framework. This course contains virtual labs. A note about virtual System Requirements: If you access the Internet from behind a proxy server, you may not be able to take a virtual lab. This affects AOL and Gateway.net users who use a modified browser and those who access virtual lab technology from behind a corporate firewall. Modified browser users should use either Internet Explorer or Netscape Navigator (both 4.0 or higher). Users behind a corporate proxy server should access virtual lab technology through a commercial ISP account. NOTE: Connection to the real PCs and servers is done via the VNS protocol. As a result, there is a requirement for a connection through ports 5800-5821 and 5900-5921.

Modules & Lessons
Assessment Results

Course Introduction
Course Introduction

Data-Centric Applications and ADO.NET
Introduction

Design of Data-Centric Applications

ADO.NET Architecture

ADO.NET and XML

Lab

Summary

Connecting to Data Sources
Introduction

Choose a .NET Data Provider

Define a Connection

Manage a Connection

Handle Connection Exceptions

Manage Connection Pooling

Lab

Summary

Performing Connected Database Operations
Introduction

Build Command Objects

Execute Command Objects That Return a Single Value

Explore Commands That Return Rows

Explore Commands That Do Not Return Rows

Investigate Transactions

Lab

Summary

Building DataSets
Introduction

Build DataSets and DataTables

Bind and Save a DataSet

Define Data Relationships

Modify Data in a DataTable

Sort and Filter Data

Lab

Summary

Reading and Writing XML with ADO.NET
Introduction

Create XSD Schemas

Load Schemas and Data into DataSets

Write XML from a DataSet

Lab

Summary

Building DataSets from Existing Data Sources
Introduction

Configure a DataAdapter to Retrieve Information

Populate a DataSet Using a DataAdapter

Configure a DataAdapter to Update the Underlying Data Source

Persist Changes to a Data Source

Handle Conflicts

Lab

Summary

Building and Consuming a Web Service That Returns Data
Introduction

Build and Consume a Web Service That Returns Data

Lab

Summary

Course Summary
Course Summary