Chapter 16. Putting It All Together

In this chapter, you will use many of the skills acquired so far to build a set of integrated applications. The goal of these applications is to track the relative sales standings of my books on C#, ASP.NET, and VB.NET.

The Overall Design

To see how various technologies work together you will actually build two independent applications (a desktop application web services client and an ASP.NET application) tied together by a backend database. Specifically, you’ll create a desktop application that obtains data from Amazon’s web service and stores it in a table in a SQL Server database, and then you’ll display that data in your ASP.NET application.[1]

The SQL Server database is very simple. It is named AmazonSalesRanks and consists of a single table, BookInfo, as shown in Figure 16-1.

Designing the BookInfo table

Figure 16-1. Designing the BookInfo table


All the fields in this table are allowed to be null because you can’t control what information may or may not be available from Amazon at any particular moment. To make this design more robust, you might consider making the ISBN a primary key and rejecting any data that returns without an ISBN. This is left, as they say, as an exercise for the reader.

Get Programming C#, 4th Edition now with the O’Reilly learning platform.

O’Reilly members experience live online training, plus books, videos, and digital content from nearly 200 publishers.