Visual Studio 2008: ADO.NET 3.5

Module 1: Getting Started with ADO.NET 3.5
This module explains how to connect to a database and retrieve data by using ADO.NET commands.

• The Structure of ADO.NET 3.5
• Connecting to a Database and Retrieving Data
• Best Practices for Managing Connections and Performing Queries

Lab: Connecting to a Database and Retrieving Data

• Connecting to a Database
• Executing a Simple Query
• Executing a Query That Returns a Result Set
• Executing a Query That Requires Parameters
  

Module 2: Modifying Data by Using ADO.NET Commands

This module explains how to modify data by using ADO.NET commands.

• Inserting, Updating, and Deleting Data
• Managing Data Integrity and Concurrency

Lab: Modifying Data by Using ADO.NET Commands

• Inserting, Updating, and Deleting Data in a Database
• Implementing Transactional Updates
• Executing Commands Asynchronously
  

Module 3: Querying and Maintaining Data by Using DataSets

This module explains how to use DataSets to fetch and modify data, and act as a local data cache.

• Creating and Using a DataSet to Retrieve Data
• Updating a Database by Using a DataSet
• Using a DataSet in an Occasionally Connected Environment 

Lab: Using a DataSet to Retrieve and Modify Data

• Creating a Typed DataSet
• Retrieving Data into a DataSet
• Modifying Data in a DataSet
• Saving a DataSet and Resolving Conflicts
  

Module 4: Querying and Maintaining Data by Using LINQ

This module explains how to use LINQ to retrieve and update data.

• Querying In-Memory Data by Using LINQ Query Expressions
• Retrieving Data by Using LINQ to SQL
• Modifying Data by Using LINQ to SQL 

Lab: Using LINQ to SQL to Retrieve and Modify Data

• Querying Data by Using LINQ to SQL Query Expressions
• Retrieving Data by Using LINQ to SQL Entity Classes
• Modifying Data by Using LINQ to SQL
• Use LINQ to SQL to modify data and save changes to the database.
   

Module 5: Implementing an Entity Model by Using the ADO.NET Entity Framework

This module explains how to use the Entity Framework to implement an entity data model for querying and maintaining data.

• Creating an Entity Data Model by Using the ADO.NET Entity Framework
• Querying and Modifying Data by Using the ADO.NET Entity Framework

Lab: Using the ADO.NET Entity Framework to Implement an Entity Data Model

• Creating an Entity Data Model
• Querying and Modifying Data in an Entity Data Model
• Instantiating and Manipulating Entities by Using Object Services
  

Module 6: Building Occasionally Connected Solutions by Using Synchronization Services

This module explains how to use Synchronization Services to build occasionally connected solutions.

• Understanding Microsoft Synchronization Services
• Downloading Data by Using Synchronization Services
• Uploading Data by Using Synchronization Services

Lab: Building Occasionally Connected Solutions by Using Synchronization Services

• Modifying a Database Schema to Support Synchronization
• Downloading Data to a Client Computer
• Uploading Data Changes to the Database

Prima di accedere a questo corso i partecipanti dovrebbero aver acquisito una certa esperienza nello sviluppo di applicazioni con Microsoft Visual Studio.