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.
| Field Name | Data Type | Description |
|---|---|---|
| FeatureID | int | An identity ... |
Get Building e-Commerce Sites with the .NET Framework now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
