Chapter 4. Building MyGolfGear.NET's Product Catalog with SQL Server 2000

IN THIS CHAPTER

Objectives

  • Understand the basic MyGolfGear.NET data model

  • Learn about the stored procedures used for managing the product catalog.

  • Understand how SQL Server database security works.

The first step in the development phase for MyGolfGear.NET was creating the product catalog with SQL Server 2000. This chapter will cover development of the data model, including support for categories, parts, and part options. This chapter also will cover the creation of stored procedures responsible for retrieving categories, parts, part details, and part options, as well as adding, updating, and deleting categories and parts.

Note

Parts and products are often used interchangeably ...

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.