Developing Data Access Solutions with Microsoft Visual Studio 2010 (M10265) M10265

Days: 5 day
Price: $2995

Course Details

In this course, you will learn to optimize your designs and develop better performing data access code by using the ADO.NET Entity Framework, LINQ, WCF Data Services, the Sync Framework, and ADO.NET.

This course will prepare you for Exam 70-516: TS: Accessing Data with Microsoft .NET Framework 4. Success on Exam 70-516 earns you the MCTS: .NET Framework 4, Data Access certification and credit towards the MCPD: Windows Developer 4 and Web Developer 4 certification.

Certification: TS: Accessing Data with Microsoft .NET Framework 4

Course Agenda

1. Architecture and Data Access Technologies

  • Data Access Technologies
  • Data Access Scenarios

2. Building Entity Data Models

  • Entity Data Models
  • Modifying the Entity Data Model
  • Customizing the Entity Data Model

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

4. Creating, Updating, and Deleting Entity Data

  • Maintaining Contact and Reward Data
  • Maintaining RewardsClaim Data

5. Handling Multi-User Scenarios by Using Object Services

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

6. Building Optimized Solutions by Using Object Services

  • 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

7. Customizing Entities and Building Custom Entity Classes

  • Overriding Generated Classes
  • Using Templates to Customize Entities
  • Creating and Using Custom Entity Classes

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

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

  • Designing an N-Tier Solution
  • Operating and Implementing Data Transport Structures
  • Protecting Data and Operations

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

11. Building Occasionally Connected Solutions

  • Offline Data Caching by Using XML
  • Using the Sync Framework

12. Querying Data by Using WCF Data Services

  • WCF Data Services
  • Creating a WCF Data Service
  • Consuming a WCF Data Service
  • Protecting Data and Operations in a WCF Data Service

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

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

Details

Options