Comments, Tags, and Ratings | ASP.NET 3.5 Social Networking

Solution

Let's take a look at our solution.

Implementing the database

Let's take a look at what is needed in the database.

SystemObjects

The SystemObjects table is at the center of this chapter's list of features. Having said that, this table is the easiest part of this equation. It simply keeps track of all the tables in the system. Specifically, it keeps track of the table names and maintains an ID for each name.

Ratings

The Ratings table is responsible for holding all the end user ratings. As you can see each rating ties back to the SystemObjects table and also directly to the record within the specified table. In addition to that, we are also tracking the Option that was rated. The most important part of this table though is the Score field. The Score tracks the selected number of stars (in our case) that the end user has selected.

System object rating options

In addition to the ratings table we also have the SystemObjectRatingOptions table. This table tracks all the options that are...

Tech Concepts

Programming languages

Tech Tools

Unlimited access to the largest independent learning library in tech of over 8,000 expert-authored tech books and videos.

Innovative learning tools, including AI book assistants, code context explainers, and text-to-speech.

50+ new titles added per month and exclusive early access to books as they are being written.

ASP.NET 3.5 Social Networking

By : Andrew Siemer

ASP.NET 3.5 Social Networking

By: Andrew Siemer

Overview of this book

Solution

Implementing the database

SystemObjects

Ratings

System object rating options

ASP.NET 3.5 Social Networking

By : Andrew Siemer

ASP.NET 3.5 Social Networking

By: Andrew Siemer

Overview of this book

Solution

Implementing the database

SystemObjects

Ratings

System object rating options

Confirmation

Buy this book with your credits?

Submit Your Feedback

Create a Free Account To Continue Reading

Sign in to activate your 7-day free access