M10265: Developing Data Access Solutions with Microsoft Visual Studio 2010

5 Day Course
Hands On
Official Microsoft Curriculum
Code M10265

This course has been retired. Please view currently available Microsoft Visual Studio Training Courses.


Collapse all

Architecture and Data Access Technologies (2 topics)

  • Data Access Technologies
  • Data Access Scenarios

Building Entity Data Models (3 topics)

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

Querying Entity Data (5 topics)

  • Retrieving Data using LINQ to Entities
  • Retrieving Data using Entity SQL
  • Retrieving Data using Entity Client
  • Retrieving Data using Stored Procedures
  • Unit Testing Data Access

Creating, Updating, and Deleting Entity Data (3 topics)

  • Understanding Change Tracking in the Entity Framework
  • Creating Data in an Entity Data Model
  • Updating Data in an Entity Data Model

Handling Multi-User Scenarios by Using Object Services (2 topics)

  • Handling Concurrency
  • Transactional Support

Building Optimized Solutions by Using Object Services (5 topics)

  • The Stages of Query Execution
  • Tracking and Object Materialization
  • Using Compiled Queries Using Design-Time generated views
  • Monitoring Performance
  • Performing Asynchronous Data Modifications

Customizing Entities and Building Custom Entity Classes (4 topics)

  • Overriding Generated Classes
  • Creating T4 Templates for Customized Code
  • Using T4 Templates
  • Creating and Using Custom Entity Classes

Using Persistence-Ignorant Classes with the Entity Framework (4 topics)

  • Requirements for Persistence-Ignorant Objects
  • Persistence-Ignorant Objects and Lazy Loading
  • Persistence-Ignorant Objects and Change Tracking
  • Interfaces and Inheritance for Custom Entity Objects

Building an N-Tier Solution by Using the Entity Framework (4 topics)

  • Building an N-Tier Solution by Using the Entity Framework
  • Designing an N-Tier Solution
  • Defining Operations and Implementing Data Transport Structures for an N-Tier Solution
  • Protecting Data and Operations

Handling Updates in an N-Tier Solution by Using the Entity Framework (2 topics)

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

Building Occasionally-Connected Solutions (2 topics)

  • Offline Caching Data using XML
  • Using the Sync Framework

Querying Data by Using WCF Data Services (4 topics)

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

Updating Data by Using WCF Data Services (3 topics)

  • Creating, Updating, and Deleting Data in a WCF Data Service
  • Preventing Unauthorized Updates and Improving Performance
  • Using WCF Data Services to Access and Update Non-Relational Data

Using ADO.NET (3 topics)

  • Retrieving and Modifying Data by Using ADO.NET Commands
  • Retrieving and Modifying Data by Using DataSets
  • Managing Transactions and Concurrency in Multi User Scenarios

Using LINQ to SQL (2 topics)

  • Designing a Logical Data Model by Using LINQ to SQL
  • Querying and Managing Data, and Handling Concurrency


Typically, this audience has the following knowledge/experience: * Experience developing n-tier applications that access various data sources * Experience implementing data binding within their applications * Some experience using LINQ and ADO.NET * A conceptual understanding of the Entity Framework In addition to their professional experience related to Data Access, students who attend this training should have the following technical knowledge: * An understanding of the problem-solving techniques that apply to software development, including the following principles of software development: modern software development models, typical phases of a software development lifecycle, concepts of event-driven programming, concepts of object-oriented programming, creating use-case diagrams, designing and building a user interface, developing a structured application * A basic understanding of the following scripting techniques and some hands-on experience writing scripts: Web scripting techniques; Macro scripting techniques; Windows scripting techniques * A general understanding of the purpose, function, and features of following .NET Framework topics: 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 * Experience using Visual Studio 2008 in the following task areas: * Declaring and initializing typed variables using the Camel case naming convention * Using arithmetic, relational, and logical operators in code statements * Using branching statements to control code execution * Using looping statements to iterate through collections or repeat steps until a specified condition is met * Creating classes and methods to establish the basic structure of an application * Using methods and events to implement the programming logic of an application * Identifying syntax and logic errors * Accessing and managing data from a data source * Experience in object oriented design and development as follows: * Creating and accessing classes and class properties * Creating and accessing methods and overloaded methods * Implementing inheritance, base classes, and abstract classes * Declaring, raising, and handling events * Responding to and throwing exceptions * Implementing interfaces and polymorphism * Implementing shared and static members * Implementing generics * Creating components and class libraries * Experience in N-Tier application design and development as follows: Managing a software development process, Controlling input at the user interface level in Windows Client and Web applications, Debugging, tracing, and profiling .NET applications, Monitoring and logging .NET applications, Implementing basic testing best practices: Performing basic Data Access tasks with LINQ, Basics of LINQ to XML, Basics of LINQ to Entities, Basics of LINQ to SQL. * Implementing basic security best practices in .NET Applications: Basics of Code Access Security, Basics of Role-Based Security, Basics of Cryptography Services * Implementing basic service calls: Basics of creating and consuming XML Web Services, Basics of creating and consuming WCF Services * Using .NET Configuration Files * Deploying .Net Framework Applications using ClickOnce and the MS Installer * Data Access experience in Windows Client application development as follows: * Connect to a data source * Implement data binding * Implement data validation at the UI layer * Data Access experience in Web application development as follows: Connect to a data source, Implement dynamic data, Implement data validation at the UI layer

Course PDF