Visual Studio

Building Microsoft Transaction Server Components with Microsoft Visual C++ 6
(Microsoft Training Course: 1596) - 3 days - £1700 exc VAT

> Target Audience
This course will teach Microsoft Visual C++ programmers, who currently build two-tier applications to access corporate databases, to build and deploy Microsoft Transaction Server (MTS) components as part of a three-tier architecture.
> Course outline
  1. Microsoft's Enterprise Development Strategy
  2. Introduction to Microsoft Transaction Server
  3. Creating MTS Components
  4. Debugging and Error Handling
  5. Managing Component State
  6. Advanced Data Access
  7. Implementing Security
  8. Using MTS Administration Objects

Supplementary InformationThis course has now retired and is no longer available. We suggest you look at Course [[{http://www.F1Comp.Co.UK/computer_training/Microsoft_Training_Courses/Visual-Studio-.Net/2124.aspx}2124: Programming with C#.]]
Module 1: Microsoft's Enterprise Development Strategy
  • Introduction to Enterprise Development
  • Island Hopper News Sample Application
  • Explain the general terms related to client/server architecture.
  • Describe the high-level architecture of an enterprise solution by using Microsoft's Enterprise Development Strategy.
  • Describe the Component Object Model (COM) and its advantages.
  • Describe the Island Hopper News sample application used as the business problem in this course.
  • List the Microsoft development tools, products, and technologies that will be used to build the solutions to the course labs.
Module 2: Introduction to Microsoft Transaction Server
  • Overview of MTS
  • MTS Architecture Using the MTS Explorer
  • Deploying an MTS Component
  • Lab: Deploying an MTS Package on a Client Computer
  • List the issues related to developing multiuser, three-tier applications and explain how MTS addresses these issues.
  • Describe the MTS architecture.
  • Create a package by using the MTS Explorer.
  • Add an existing component to an MTS package.
  • Configure a client computer to use MTS components.
Module 3: Creating MTS Components
  • Overview of MTS Transaction Services
  • Building MTS Components
  • Lab: Creating an MTS Component
  • Describe what a transaction is and how it conforms to the ACID properties.
  • Describe how MTS manages context for objects.
  • Participate in transactions by calling the SetComplete, SetAbort, EnableCommit, or DisableCommit methods of the MTS ObjectContext object.
Module 4: Debugging and Error Handling
  • Handling Errors in MTS
  • Debugging a Component
  • Debugging and Monitoring Tools
  • Analyzing Application Performance by Using Microsoft Visual Studio Analyzer
  • Lab: Using Microsoft Visual Studio Analyzer
  • Debug an MTS object at run time.
  • Use MTS Spy to monitor component activity.
  • Analyze the performance of an application by using Microsoft Visual Studio Analyzer.
Module 5: Managing Component State
  • Overview of Managing Component State
  • Just-in-Time Activation
  • The IObjectControl Interface
  • Storing Object State
  • The Shared Property Manager
  • Lab: Using the Shared Property Manager
  • Explain how just-in-time activation affects object state.
  • Use the IObjectControl interface to define context-specific initialization and cleanup procedures.
  • Explain the usefulness of storing state and sharing state between components.
  • Use the Shared Property Manager to store the shared state of MTS components.
Module 6: Advanced Data Access
  • Using Stored Procedures
  • Using ADO and OLE DB in a Distributed Environment
  • Disconnected Recordsets
  • Converting an OLE DB Rowset to an ADO Recordset
  • Session Pooling
  • Data Access Best Practices
  • ADO Best Practices
  • OLE DB Best Practices
  • Lab: Creating a Disconnected Recordset
  • Lab: Converting OLE DB Data to ADO
  • Choose the appropriate cursor locations, cursor types, and lock types for different enterprise scenarios.
  • Create a disconnected recordset and perform batch updates.
  • Convert an OLE DB rowset into an ADO recordset.
  • Manage database connections efficiently through session pooling.
Module 7: Implementing Security
  • Introduction to Security
  • Implementing Declarative Security in MTS Applications
  • Implementing Programmatic Security in MTS Applications
  • Implementing Security in SQL Server
  • Security Best Practices
  • Lab: Implementing Declarative Security in MTS Applications
  • Lab: Implementing Programmatic Security in MTS Applications
  • Lab: Implementing Security in SQL Server
  • List the advantages of three-tier security over two-tier security in enterprise solutions.
  • Implement declarative security for MTS packages by using MTS roles and Windows NT user and group accounts.
  • Implement programmatic security for MTS packages by using the security methods of IObjectContext and IsecurityProperty.
  • Assign permissions to login by using SQL Server Enterprise Manager.
  • List best practices associated with implementing security in enterprise solutions.
Module 8: Using MTS Administration Objects
  • MTS Administration Objects
  • Scriptable Object Hierarchy
  • Working with Packages
  • Working with Components
  • MTS Administration Programming Best Practices
  • Lab: Creating a Deployment Program for a Package
  • Create, delete, and modify packages and components by using the MTS Administration objects.
> Pre-Requisites
Before attending this course, the student must have the following pre-requisites:
  • Intermediate programming competency with the Microsoft Visual C++ product.
  • Completed Course 1304, Component Development Using the Active Template Library 3.0
  • Completed Course 1595, Accessing Data with Microsoft Visual C++ 6
  • OR Course 1015, Mastering MFC Development Using Microsoft Visual C++ 6.
> Purpose
At the end of the course, students will be able to describe the architecture of an enterprise solution by using the Microsoft Windows Distributed interNet Application (DNA) architecture; identify the key tools and technologies in Microsoft's Enterprise Strategy; create Component Object Model (COM) objects that use MTS services; implement MTS objects that access data from a data source by using ActiveX Data Objects (ADO) and OLE DB consumer templates; use disconnected recordsets to return data to a client; apply security techniques such as MTS role-based security, Windows NT security, and SQL Server security to three-tier applications; debug MTS object errors by using tools such as MTS Spy; implement error handling in MTS objects; use MTS Administration Objects to automate deployment of MTS packages and components.
> Supplementary Information
This course has now retired and is no longer available. We suggest you look at Course [[{http://www.F1Comp.Co.UK/computer_training/Microsoft_Training_Courses/Visual-Studio-.Net/2124.aspx}2124: Programming with C#.]]