Working With Local Data Access Technologies

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


Expected Duration
192 minutes

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.


Introducing Windows Azure and Web Services

  • 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
  • Using ADO.NET to Query and Manipulate Data

  • 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
  • LINQ Fundamentals

  • describe LINQ and its uses
  • use basic LINQ to Objects queries
  • issue advanced LINQ queries
  • use LINQ to update back-end data sources
  • Manipulating XML Data Structures

  • 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
  • Implementing Caching

  • 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
  • Implementing Transactions

  • 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
  • Practice: Understand Web Services and Data Access

  • identify web services and local data storage and access




    Multi-license discounts available for Annual and Monthly subscriptions.