Message Boards | ASP.NET 3.5 Social Networking

Solution

Let's take a look at our solution.

Implementing the Database

Let's start our solution by first discussing the implementation of our database.

Categories

As we discussed before, the concept of a category is our top level container of data. Let's take a look at the table structure for categories:

The SortOrder field is in charge of setting the display order in case we have multiple categories on one page. We already discussed the count fields earlier. The last X fields are to control who made the last post and when. PageName controls the friendly URLs that our system will use later.

Note

Some of you may notice that the name of this table is BoardCategorys instead of BoardCategories. I have noticed that while dragging some spellings into the LINQ to SQL designer I get odd spellings for my object names. Where I could go in and rename the objects for each table I find that it is easier to just work with the issue in a way that LINQ to SQL will generate what I want in the first place. This...

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

Categories

Note

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

Categories

Note

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