Working With Local Data Access Technologies


Overview/Description
Target Audience
Prerequisites
Expected Duration
Lesson Objectives
Course Number
Expertise Level


Overview/Description
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.

Prerequisites
None

Expected Duration (hours)
3.2

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:
    cl_mazw_a01_it_enus

    Expertise Level
    Beginner