O'Reilly logo

Applied Architecture Patterns on the Microsoft Platform - Second Edition by Gregor Noriskin, Dmitri Olechko, Andre Dovgal

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Building the payroll processor application

Over the next few pages, we shall present some essential aspects of SQL Server development. We'll see how we can work with different data sources, structure them, and present them through the report engine. We'll see how we can display the data using the web user interface.

Let's analyze the following use case and see how we can use SQL Server to implement our solution.

Use case

Reliable Payroll Pro Inc. (RPP) is a payroll processor for a large number of small- to medium-sized companies. The core business workflow may be described in the following steps:

  1. Collect the employee and payroll data from the client.
  2. Process data to produce the following:
    • Tax forms and checks
    • Payroll checks and direct deposit requests ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required