Digi Academy

Visual Studio 2008: ADO.NET 3.5

Digi Academy
A Milano

Chiedi il prezzo
Chiedi informazioni a un consulente Emagister

Informazioni importanti

Tipologia Corso
Luogo Milano
Inizio Scegli data
  • Corso
  • Milano
  • Inizio:
    Scegli data
Descrizione

Introduction to ADO.NET 3.5 Connecting to a Database and Retrieving Data Best Practices for Managing Connections and Performing Queries Connecting to a Database Executing a Simple Query Executing a Query That Returns a Result Set

Strutture (1)
Dove e quando
Inizio Luogo
Scegli data
Milano
Via Valtellina, 63, 20124, Milano, Italia
Visualizza mappa
Inizio Scegli data
Luogo
Milano
Via Valtellina, 63, 20124, Milano, Italia
Visualizza mappa

Cosa impari in questo corso?

Visual Studio 2010
Visual studio 2008
Framework
Visual Studio
SQL

Programma

Executing a Query That Requires a Parameter


After completing this module, students will be able to:



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.


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


Inserting, Updating, and Deleting Data


Managing Data Integrity and Concurrency


Inserting, Updating, and Deleting Data in a Database


Implementing Transactional Updates


Executing Commands Asynchronously


After completing this module, students will be able to:



Insert, update, and delete data by using ADO.NET Command objects.


Implement transactions to control data integrity and concurrency.


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


Creating a Typed DataSet


Retrieving Data into a DataSet


Modifying Data in a DataSet


Saving a DataSet and Resolving Conflicts


After completing this module, students will be able to:



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.


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


Defining Entity Classes


Retrieving Data by Using LINQ to SQL


Modifying Data by Using LINQ to SQL


After completing this module, students will be able to:



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.


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


Creating an Entity Data Model


Querying Entities in an Entity Data Model


Modifying Entities in an Entity Data Model


After completing this module, students will be able to:



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.


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


Modifying a Database Schema to Support Synchronization


Downloading Data to a Client Computer


Uploading Data Changes to the Database


After completing this module, students will be able to:



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.



Gli utenti che erano interessati a questo corso si sono informati anche su...
Leggi tutto