Friends | ASP.NET 3.5 Social Networking

Solution

Now let's look at our solution.

Implementing the Database

Let's look at the tables that are needed to support these new features.

The Friends Table

As the concept of friends is our base discussion for this chapter, we will immediately dive in and start creating the tables around this subject. As you have seen previously this is very straightforward table structure that simply links one account to the other.

All these fields should be totally understandable. Here's the SQL:

CREATE TABLE [dbo].[Friends](
   [FriendID] [int] IDENTITY(1,1) NOT NULL,
   [AccountID] [int] NOT NULL,
   [MyFriendsAccountID] [int] NOT NULL,
   [CreateDate] [smalldatetime] NOT NULL CONSTRAINT 
               [DF_Friends_CreateDate]  DEFAULT (getdate()),
   [Timestamp] [timestamp] NOT NULL,
 CONSTRAINT [PK_Friends] PRIMARY KEY CLUSTERED 
(
   [FriendID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, 
      IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  
      = ON) ON [PRIMARY]
) ON...

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 Friends Table

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 Friends Table

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