User Profiles | ASP.NET 3.5 Social Networking

Solution

Now, let's take a look at how we can go about implementing these new features.

Implementing the database

We will start by implementing our database and work our way up from there.

The Profiles table

Before we can really put an interface together, we need to discuss how the data for a profile will be stored. Here is the profiles table:

So let's discuss some of the fields that are somewhat less than normal. In this case, I am referring to the varbinary(MAX) field for the Avatar storage. With the MAX size constraint (not much of a constraint!), a person could technically store a DVD in this field. This of course would be ridiculous, so we need to make sure that there are some constraints on the front end so that file storage size is kept to a minimum. As you will see later, this field is essentially a character array!

Level of Experience

Once we have our base profile container in place, we can create some of the surrounding tables. The easiest of which is the level of experience system...

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

The Profiles table

Level of Experience

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

The Profiles table

Level of Experience

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