Indirizzato a

Programmatori che desiderano approfondire le proprie conoscenze circa le tecnologie per realizzare applicazioni distribuite.

Presentazione

Questo corso fornisce ai partecipanti la preparazione e le competenze necessarie per sviluppare applicazioni di accesso ai dati utilizzando il Microsoft Framework .NET e Microsoft Visual Studio 2005. Il corso tratta l'accesso e l'aggiornamento dati di un database con ADO.NET ed illustra anche la creazione, lettura e scrittura di dati in XML. Il corso, di natura principalmente pratica, è stato pensato per sviluppatori aziendali o indipendenti che desiderano approfondire la loro conoscenza nelle aree tecnologiche relative allo sviluppo di applicazioni distribuite.

Obiettivi
Al termine del corso i partecipanti saranno in grado di:
connettersi a un database e leggere i dati;
interrogare e aggiornare un database;
eseguire transazioni;
eseguire operazioni di tipo disconnected mediante i wizard di Visual Studio 2005;
eseguire operazioni XML su dati di tipo disconnected;
leggere e scrivere dati XML;
processare dati XML mediante il Document Object Model DOM;

Certificazioni
70-526: TS: Microsoft® .NET Framework 2.0 - Windows®-Based Client Development
70-528: TS: Microsoft® .NET Framework 2.0 - Web-Based Client Development
70-529: TS: Microsoft .NET Framework 2.0 - Distributed Application Development
70-551: UPGRADE: MCAD Skills to MCPD Web Developer by Using the Microsoft® .NET Framework
70-552: UPGRADE: MCAD Skills to MCPD Windows® Developer by Using the Microsoft® .NET Framework
70-553: UPGRADE: MCSD Microsoft® .NET Skills to MCPD Enterprise Application Developer by Using the Microsoft® .NET Framework: Part 1
Attestato di frequenza MOC 2541

Programma

Connecting to Databases and Reading DataWhat Is ADO.NET?
The Process for Connecting to a Database and Reading Data
What Is Connection Pooling?
Exercise 1. Connecting to a Database
Exercise 2. Saving a Connection String Securely in an Application
Configuration File
Exercise 3. Retrieving Data from a Database
Exercise 4. Handling Connection Events and Exceptions
Exercise 5. Configuring and Using Connection Pooling (if time permits)

Querying and Updating Databases by Using Commands
ADO.NET Commands
The Process for Passing Parameters into Commands
Exercise 1. Creating and Running Query Commands
Exercise 2. Creating and Running Parameterized Commands
Exercise 3. Creating and Running Update Commands
Exercise 4. Using Globalized Formats for Storing and Accessing Data (if time
permits)

Performing Transactional Operations
What Is a Transaction?
The Process for Managing Local Transactions
The Process for Managing Distributed Transactions
Isolation Levels
Exercise 1. Performing Data Updates within a Transaction
Exercise 2. Choosing an Appropriate Isolation Level for a Transaction
Exercise 3. Enlisting in a Distributed Transaction
Exercise 4. Managing Transactions in the Data Tier (if time permits)

Performing Disconnected Operations Programmatically
What Is the ADO.NET Disconnected Model?
The Process for Loading and Saving Data in a DataSet
What Are DataViews?
Exercise 1. Creating a DataSet Programmatically
Exercise 2. Populating and Saving a DataSet
Exercise 3. Adding, Modifying, and Deleting Data in a DataSet
Exercise 4. Merging DataSets
Exercise 5. Creating and Using DataViews (if time permits)

Performing Disconnected Operations by Using Visual Studio 2005 Wizards
Comparing Untyped DataSets with Typed DataSets
What Are Table Adapters?
Demonstration: Creating a Typed DataSet by Using Visual Studio 2005
Wizards
Exercise 1. Creating a Typed DataSet by Using the DataSet Designer
Exercise 2. Loading, Displaying, and Saving Data in a Typed DataSet
Exercise 3. Adding Code to a Typed DataSet
Exercise 4. Creating a Typed DataSet by Using the Data Source
Configuration Wizard
Exercise 5. Adding Queries to a Table Adapter (if time permits)

Performing XML Operations on Disconnectedn Data

XML Representations of DataSets
What Are DiffGrams?
Exercise 1. Saving a DataSet as XML Data
Exercise 2. Loading a DataSet from XML
Exercise 3. Saving and Loading DataSet Schema Information

Reading and Writing XML Data
The Process for Serially Reading XML Data
The Process for Serially Writing XML Data
Exercise 1. Writing XML Data by Using XmlWriter
Exercise 2. Reading XML Data by Using XmlReader

Processing XML Data by Using DOM
What Is DOM?
What Are DOM Trees?
Types of XML Nodes in a DOM Tree
Exercise 1. Reading XML Data by Using DOM
Exercise 2. Writing XML Data by Using DOM