Working With Local Data Access Technologies

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.0

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