Working With Local Data Access Technologies

This course is included in our On-demand training solution.


This course covers the foundations of data access in the Microsoft .NET Framework and how to choose between data access technologies, and is one of a series that prepares students for Microsoft exam 70-487.

Target Audience

Developers wanting to understand the fundamentals of data access in .NET and those preparing for Microsoft exam 70-487.



Expected Duration

180 min.

Course Objectives

Course Introduction

Introduction to Web Services and Windows Azure

  • explain .NET web services and use of the Windows Azure platform
  • Choosing a Web Service Technology

  • choose a technology for creating a web service based on application requirements
  • Understanding Data Access in the .NET Framework

  • understand how a .NET application connects to and queries a data source
  • Using ADO.NET to Query a SQL Server Database

  • use ADO.NET to query a SQL Server database
  • Reading Data Using an ADO.NET DataReader

  • use an ADO.NET DataReader to read data from a data source
  • Reading Data into a DataSet with ADO.NET

  • use ADO.NET to retrieve data from a data source into an in-memory dataset
  • ADO.NET – Using DbCommand to Update Data

  • insert, update, and delete records from a data source using the DbCommand class
  • ADO.NET – Using DataSet to Update Data

  • insert, update, and delete records from an in-memory dataset and backing data source
  • ADO.NET – Working with SQL Server Stored Procedures

  • retrieve and update database data using SQL Server stored procedures
  • ADO.NET – Synchronous and Asynchronous Operations

  • perform synchronous and asynchronous database operations
  • Introducing LINQ

  • describe LINQ and its uses
  • LINQ To Objects Queries

  • use basic LINQ to Objects queries
  • Advanced LINQ Queries

  • issue advanced LINQ queries
  • Updating Data Using a LINQ Data Context

  • use LINQ to update back-end data sources
  • Understanding XML Data Structures

  • explain the uses of XML data structures
  • Reading XML Data

  • read XML data using XMLReader and XMLDocument
  • Manipulating XML Data Using XMLWriter

  • write and update an XML hierarchy using XMLWriter
  • Basic Xpath Queries

  • understand Xpath and execute basic Xpath queries
  • Transforming XML Using XSLT

  • transform XML using XSLT
  • Querying XML Data with LINQ to XML

  • query an XML document using LINQ to XML
  • Updating XML Data with LINQ to XML

  • update an XML document using LINQ to XML
  • Introducing Caching

  • understand caching and how to read and write basic cache entries
  • Applying Caching Policies

  • apply caching policies
  • Cache Updating Using CacheDependency

  • use CacheDependency to update a cache periodically or in response to a trigger
  • Cache Updating Using SQL Server Query Notifications

  • use a SQL Server query notification to trigger a cache update
  • Introducing Transactions

  • understand transactions and their use
  • Managing Transactions Using Explicit ADO.NET Classes

  • create and manage transactions directly against ADO.NET objects
  • Managing Transactions Using System.Transactions

  • create and manage transactions using high-level objects in the System.Transactions namespace
  • Understanding Distributed Transactions

  • understand a simple distributed transaction
  • Implementing Distributed Transactions

  • implement a simple distributed transaction
  • Understanding Transaction Isolation Levels

  • understand and specify transaction isolation levels
  • Exercise: Understand Web Services and Data Access