Using Query Notifications and Synchronizing Data with Visual Basic 2008


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



Overview/Description
Query notifications, coupled with ADO.NET synchronization services, allow developers to create applications with the ability to display up-to-date data at all times. This course examines how to use query notifications with SQL Server and how to enable efficient, remote use of data using synchronization services. Specific topics covered include using query notifications, and SqlDependency and SqlCacheDependency. Topics also look at the various aspects of synchronizing data, including creating a synchronization services application and configuring synchronization in Visual Studio. This course is one of a series in the SkillSoft learning path that covers the objectives for the Technology Specialist (TS): Microsoft .NET Framework 3.5, ADO.NET Application Development 70-561. Passing this exam will earn the learner credit towards the MCTS: .NET Framework 3.5, ADO.NET Applications certification.

Target Audience
All organizations or individual consultants who are building or intend to build .NET Framework 3.5 applications with ADO.NET, Visual Studio 2008 and Visual Basic 2008; corporate employees, consultants, and university or college students who are preparing for the Technology Specialist (TS): Microsoft .NET Framework 3.5, ADO.NET Application Development 70-561.

Prerequisites
Thorough knowledge of software-development concepts and the process of building business applications; experience building data applications with the Microsoft .NET Framework; working experience of Visual Studio 2008, Visual Basic 2008, and ADO.NET 3.5.

Expected Duration (hours)
2.0

Lesson Objectives

Using Query Notifications and Synchronizing Data with Visual Basic 2008

  • recognize the code for executing a SqlCommand with a SqlNotificationRequest
  • recognize the steps for using SqlDependency to detect changes
  • identify the steps for using a SqlCacheDependency object
  • use SqlDependency to detect changes
  • use query notifications in an ASP.NET application
  • recognize the benefits and uses of Microsoft Synchronization Services for ADO.NET
  • identify the architectural requirements for implementing client and server synchronization
  • recognize the uses and benefits of classes used in Synchronization Services
  • recognize the steps for creating synchronization tables and groups
  • recognize the steps for retrieving an anchor value and creating a synchronization adapter
  • recognize the steps for coding statistics and events
  • recognize the steps for building a basic synchronization services application
  • recognize the steps for configuring the cache for synchronization using Microsoft Synchronization Services
  • code the synchronization providers
  • code the synchronization agent
  • code statistics and events
  • call the Synchronization method
  • Course Number:
    sd_mand_a06_it_enus