GKI -
GKI - Learning. To Make a Difference.
Ricerca   
 
 
Select your country
 
Catalogo Corsi > Microsoft > Visual Studio 2008: ADO.NET 3.5 (MS-6464)
MS-6464

Visual Studio 2008: ADO.NET 3.5

Classroom learning Virtual Learning E-learning On-site learning

Questo corso fornisce ai partecipanti le conoscenze necessarie per accedere e modificare dati utilizzando ADO.NET 3.5.



Cosa si impara

A conclusione del corso, lo studente sarà in grado di:

  • Describe the purpose and structure of ADO.NET 3.5.
  • Explain the role of data providers in ADO.NET 3.5.
  • List the technologies and techniques available for managing data with ADO.NET 3.5.
  • Insert, update, and delete data by using ADO.NET Command objects.
  • Implement transactions to control data integrity and concurrency.
  • Define and use a DataSet for retrieving data.
  • Use a DataSet to update a database.
  • Use a DataSet as a local cache in an occasionally connected environment.
  • Define LINQ queries for selecting data from an in-memory data structure.
  • Use LINQ to SQL to query data in a database.
  • Use LINQ to SQL to modify data and save changes to the database.
  • Explain how to use the ADO.NET Entity Framework to map a database schema to a logical business model.
  • Use the ADO.NET Entity Framework to query and manage data.
  • Explain how Synchronization Services supports occasionally-connected solutions.
  • Use Synchronization Services to download data from a SQL Server database.
  • Use Synchronization Services to upload data to a SQL Server database.

Cosa si impara


Chi dovrebbe partecipare

Questo corso è rivolto agli sviluppatori di applicazioni che sanno come creare applicazioni in Visual Studio 2005 o 2008.


Visualizza tutto   Nascondi tutto/Nascondi tutto

Vedi/Nascondi  Contenuto dettagliato

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

Vedi/Nascondi  Contenuto dettagliato

Vedi/Nascondi  Contenuto dettagliato

Vedi/Nascondi  Prerequisiti

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

Vedi/Nascondi  Corsi successivi

Vedi/Nascondi  Esami / Certificazioni



 
Iscriviti al corso
Classroom learning Classroom learning Vedi/Nascondi
Prezzo: € 710 - Durata: 2 Giorni
Virtual learning Virtual learning Vedi/Nascondi
E-learning E-learning Vedi/Nascondi

 

On-site learning On-site learning Vedi/Nascondi
Per informazioni e iscrizioni: n° verde 800-824.017, e-mail info.it@gki.it
 

Info

 

 

Info

 

 

Info