Working With Local Data Access Technologies

Target Audience
Expected Duration
Lesson Objectives
Course Number
Expertise Level

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 (hours)

Lesson Objectives

Working With Local Data Access Technologies

  • start the course
  • explain .NET web services and use of the Windows Azure platform
  • choose a technology for creating a web service based on application requirements
  • understand how a .NET application connects to and queries a data source
  • use ADO.NET to query a SQL Server database
  • use an ADO.NET DataReader to read data from a data source
  • use ADO.NET to retrieve data from a data source into an in-memory dataset
  • insert, update, and delete records from a data source using the DbCommand class
  • insert, update, and delete records from an in-memory dataset and backing data source
  • retrieve and update database data using SQL Server stored procedures
  • perform synchronous and asynchronous database operations
  • describe LINQ and its uses
  • use basic LINQ to Objects queries
  • issue advanced LINQ queries
  • use LINQ to update back-end data sources
  • explain the uses of XML data structures
  • read XML data using XMLReader and XMLDocument
  • write and update an XML hierarchy using XMLWriter
  • understand Xpath and execute basic Xpath queries
  • transform XML using XSLT
  • query an XML document using LINQ to XML
  • update an XML document using LINQ to XML
  • understand caching and how to read and write basic cache entries
  • apply caching policies
  • use CacheDependency to update a cache periodically or in response to a trigger
  • use a SQL Server query notification to trigger a cache update
  • understand transactions and their use
  • create and manage transactions directly against ADO.NET objects
  • create and manage transactions using high-level objects in the System.Transactions namespace
  • understand a simple distributed transaction
  • implement a simple distributed transaction
  • understand and specify transaction isolation levels
  • identify web services and local data storage and access
  • Course Number:

    Expertise Level