Product Spotlight Database Object

To implement the MyGolfGear.NET product spotlight feature, we added three new database objects. Specifically, we added a new table called FeaturedItems. Additionally, we added the two new stored procedures spInsertFeaturedItem and spGetFeaturedItems.

The FeaturedItems Table

The new MyGolfGear table named FeaturedItems was added. This simple table has only four columns: FeatureID, ProductID, StartDate, and EndDate. Table 7.1 describes the fields and types used in this table.

Note

Some sites rotate their spotlight features based on page views. We chose to rotate the MyGolfGear.NET product spotlights based on the date.

Table 7.1. The FeaturedItems Table
Field Name Data Type Description
FeatureID int An identity ...

Get Building e-Commerce Sites with the .NET Framework now with O’Reilly online learning.

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