Caricamento...
MOC10265

Developing Data Access Solutions with Microsoft Visual Studio 2010

Prezzo

€ 1,600.00
(Iva esclusa)

Scheda tecnica

Scarica

Giorni

4.5 gg

Questo corso si rivolge a programmatori esperti nell'accesso dati da applicazioni Windows client e/o Web. In questo corso impareranno ad affinare le tecniche di progettazione e di gestione delle performance utilizzando ADO.NET Entity Framework, LINQ, WCF Data Services, Sync Framework e ADO.NET.


OBIETTIVI

Al termine del corso gli allievi saranno in grado di:

  • Valutare diversi casi di business e identificare la tecnologia di accesso ai dati più approppriata;
  • Utilizzare i tool forniti con l'Entity Framework;
  • Eseguire query a un Entity Data Model utilizzando metodologie quali LINQ to Entities, Entity SQL, e le classi nell'EntityClient namespace;
  • Eseguire task di modifica dati in un EDM;
  • Spiegare il significato dell'Object Services model implementato dall'Entity Framework e il supporto fornito dalle Object Services API;
  • Descrivere le best practices per la progettazione e realizzazione di un data access layer ottimizzato utilizzando gli Object Services;
  • Personalizzare e estendere entità;
  • Riutilizzare classi in un data access layer creato mediante l'Entity Framework;
  • Valutare le problematiche di tipo architetturale che possono presentarsi realizzando una applicazione n-tier mediante l'Entity Framework;
  • Accedere a dati offline o a dati a disponibilità limitata in applicazioni client;
  • Progettare, sviluppare e consumare un semplice WCF Data Service;
  • Utilizzare i WCF Data Services per aggiornare e cancellare dati;
  • Sviluppare applicazioni ADO.NET scalabili e ad alte prestazioni
Programmatori

Per partecipare con profitto a questo corso è necessario che gli allievi abbiano i seguenti prerequisiti:

Comprensione ed esperienza nell'utilizzo di tecniche di problem-solving applicate allo sviluppo di software;

Conoscenza di base di tecniche di scripting;

Conoscenza generale del singificato e della funzione delle seguenti caratteristiche di .NET Framework:

  • Common Language Runtime
  • .NET Framework class library
  • Common Type System
  • Component interoperation
  • Cross-language interoperability
  • Assemblies in the Common Language Runtime
  • Application domains
  • Runtime hosts supported by the .NET Framework

Esperienza nell'utilizzo di Visual Studio 2008;

Eperienza nella progettazione e sviluppo object-oriented;

Esperienza nella progettazione e sviluppo di applicazioni n-tier;

Esperienza nell'utilizzo di tecniche di accesso ai dati da applicazioni Windows client;

Esperienza nell'utilizzo di tecniche di accesso ai dati da applicazioni Web.

Module 1: Architecture and Data Access Technologies

  • Data Access Technologies
  • Data Access Scenarios
  • Identifying Data Access Technologies

Module 2: Building Entity Data Models

  • Introduction to Entity Data Models
  • Modifying the Entity Data Model
  • Customizing the Entity Data Model
  • Generating an EDM from the AdventureWorks Database
  • Adding Entities and Associations
  • Using the Generate Database Wizard
  • Mapping Entities to Multiple Tables
  • Implementing an Inheritance Hierarchy
  • Using Stored Procedures
  • Creating a Complex Type

Module 3: Querying Entity Data

  • Retrieving Data by Using LINQ to Entities
  • Retrieving Data by Using Entity SQL
  • Retrieving Data by Using EntityClient Provider
  • Retrieving Data by Using Stored Procedures
  • Unit Testing Your Data Access Code
  • Retrieving All Contact Entities
  • Retrieving Contact Entities by Using a Filter
  • Retrieving RewardsClaimed Entities
  • Querying the Rewards Family of Entities
  • Executing a Stored Procedure

Module 4: Creating, Updating, and Deleting Entity Data

  • Understanding Change Tracking in the Entity Framework
  • Modifying Data in an Entity Data Model
  • Maintaining Contact and Reward Data
  • Maintaining RewardsClaim Data

Module 5: Handling Multi-User Scenarios by Using Object Services

  • Handling Concurrency in the Entity Framework
  • Transactional Support in the Entity Framework
  • Handling Concurrency of Rewards Claimed Data
  • Updating the RewardsClaimed and ArchivedRewardsClaimed Information by Using a Transaction

Module 6: Building Optimized Solutions by Using Object Services

  • The Stages of Query Execution
  • Change Tracking and Object Materialization
  • Using Compiled Queries
  • Using Design-Time Generated Entity Framework Views
  • Monitoring Performance
  • Performing Asynchronous Data Modifications
  • Improving the Performance of Query Operations
  • Improving the Performance of Update Operations

Module 7: Customizing Entities and Building Custom Entity Classes

  • Overriding Generated Classes
  • Using Templates to Customize Entities
  • Creating and Using Custom Entity Classes
  • Using a Template to Add Custom Functionality to Entity Classes
  • Creating Custom Entity Classes

Module 8: Using POCO Classes with the Entity Framework

  • Requirements for POCO Classes
  • POCO Classes and Lazy Loading
  • POCO Classes and Change Tracking
  • Extending Entity Types
  • Using POCO Classes
  • Extending Your POCO Classes

Module 9: Building an N-Tier Solution by Using the Entity Framework

  • Designing an N-Tier Solution
  • Defining Operations and Implementing Data Transport Structures
  • Protecting Data and Operations
  • Creating the Contacts and Orders Data Access Tier
  • Protecting Data Access Operations

Module 10: Handling Updates in an N-Tier Solution by Using the Entity Framework

  • Tracking Entities and Persisting Changes
  • Managing Exceptions in an N-Tier Solution
  • Handling Updates in the Data Access Tier
  • Detecting and Handling Order Conflicts

Module 11: Building Occasionally Connected Solutions

  • Offline Data Caching by Using XML
  • Using the Sync Framework
  • Modifying the Orders Application to Use Offline XML Data
  • Modifying the Orders Application to Synchronize Locally Cached Data

Module 12: Querying Data by Using WCF Data Services

  • Introduction to WCF Data Services
  • Creating a WCF Data Service
  • Consuming a WCF Data Service
  • Protecting Data and Operations in a WCF Data Service
  • Exposing Order Data as a WCF Data Service
  • Consuming a WCF Data Service
  • Restricting Access to Data Exposed by a WCF Data Service
  • Implementing a Business Operation in a WCF Data Service

Module 13: Updating Data by Using WCF Data Services

  • Creating, Updating, and Deleting Data in a WCF Data Service
  • Preventing Unauthorized Updates and Improving Performance
  • Using WCF Data Services with Nonrelational Data
  • Updating Entities by Using a WCF Data Service
  • Creating and Deleting Entities by Using a WCF Data Service
  • Restricting Create, Update, and Delete Requests

Module 14: Using ADO.NET

  • Retrieving and Modifying Data by Using ADO.NET Commands
  • Retrieving and Modifying Data by Using DataSets
  • Managing Transactions and Concurrency in Multiuser Scenarios
  • Using ADO.NET to Retrieve Read-Only Information Quickly and Perform Simple Data Modifications
  • Developing the Product List Web Application
  • Enabling Data Modifications

Module 15: Using LINQ to SQL

  • Implementing a Logical Data Model by Using LINQ to SQL
  • Managing Performance and Handling Concurrency
  • Using LINQ to SQL to Build a Data Access Layer
  • Updating a Database by Using a Stored Procedure
  • Building a Custom Entity Class.


Sede Data P