MCTS Exam 70-516 Accessing Data with Microsoft .NET Framework 4

Module 1: Data Access Technologies in .NET

  • Introduction to ADO.NET Architecture
    • Consuming Data
    • Writing SQL Queries
    • Using DataReader,DbAdapter,DbTableAdapter
  • Introduction to Datasets:Dataset class hierarchy,Dataset Datatypes,User defined datatypes
    • Creating relationships in Datasets:DataRelation class, DataView
    • Validation and Errors on DataSet
    • DataTableReader class
    • Creating Typed datasets:TableAdapter

Module 2: Building Entity Data Models

  • Generating and Querying an Entity Data Model(EDM)
  • Querying data using Object Services
  • Overriding Generated Classes
  • Using Templates to Customize Entities
  • Creating and Using Custom Entity Classes

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

Module 4: Creating, Updating, and Deleting Entity Data

  • Understanding Change Tracking in the Entity Framework
  • Modifying Data in an Entity Data Model
  • Customizing the Entity Data Model

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

  • Handling Concurrency in the Entity Framework
  • Transactional Support in the Entity Framework

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

Module 7: Using POCO Classes with the Entity Framework

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

Module 8: 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

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

  • Tracking Entities and Persisting Changes
  • Managing Exceptions in an N-Tier Solution

Module 10: Building Occasionally Connected Solutions

  • Microsoft Sync Framework
  • Offline Data Caching by Using XML
  • Sync Services for ADO.NET

Module 11: 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

Module 12: 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

Module 13: Using LINQ to SQL

  • LINQ to SQL in disconnected mode
  • LINQ to SQL using Stored Procedures
  • DataContext,Mapping,
  • LINQ To SQL Data updation