Microsoft® .NET Distributed Applications: Integrating XML Web Services and .NET Remoting

The Data Layer

The first step in creating this system is to build the database. In our case, we’ll use a fairly simple set of tables so we can focus on the overall architecture rather than mundane details such as setting multiple fields and adding stored procedure parameters. In a typical business system, the logic would closely match our example, but the database tables would be expanded. For example, the Products table would probably require additional fields to track detailed product information. The database might also include additional tables such as ProductCategories.

Figure 16-3 shows the business-specific tables for our stripped-down data layer. Essentially, there are two order-specific tables: Orders, which includes a record for each ...