Groups

Solution

Now let's take a look at our solution.

Implementing the database

Let's take a look at what we need to implement the database.

Here is the Groups table structure:

The majority of this table is self-explanatory. However, one thing to be very aware of is the Body field, which is varchar(MAX) here. This means that people could technically put any amount of text that they want here. If this is not the functionality that you want to provide, either make this field smaller or put some form of client-side validation on this field to restrict its size.

You may also be wondering why we have a large Description field and an even larger Body field. The primary reason for this is so that we have public and private fields of text. A description could simply be the first paragraph of the Groups' page text, or it could be a brief synopsis. This totally depends on how you structure your output. I have set it up so that the description and body show up together, with the description on top.

Another...

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

Groups

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

Groups

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