Browse Library
Sign In Start Free Trial
Close icon Search icon
Account
Browse Library Sign In Start Free Trial

Add to playlist

Create a Playlist

Modal Close icon
You need to login to use this feature.
  • Book Overview & Buying ASP.NET 3.5 Social Networking
  • Table Of Contents Toc
ASP.NET 3.5 Social Networking

ASP.NET 3.5 Social Networking

By : Andrew Siemer
4.1 (10)
Buy this Book
close
close
ASP.NET 3.5 Social Networking

ASP.NET 3.5 Social Networking

4.1 (10)
By: Andrew Siemer
Buy this Book

Overview of this book

Each chapter starts by showing the user experience we are going to create in the chapter. It then has a section discussing the major design decisions we face in building these features, and finally presents the 'solution' – including the overall architecture and highlighting the most important code elements. The book presents a lot of real-world code, with comprehensive explanation and discussion. The full social network application is available for download from the Packt website, for you to examine, study, and modify. This book is written for ASP.NET and C# developers who want to build an enterprise-grade Social Network, either for their own business purposes or as a contract job for another company. The book assumes you have prior experience of developing web applications using ASP.NET 3.5, C# 3.0, SQL Server 2005/2008, and Visual Studio .NET 2008; it focuses on topics that will be of interest to existing developers – not on providing step-by-step examples for each detail.
Table of Contents (19 chapters)
close
close
close
ASP.NET 3.5 Social Networking
Icon
ASP.NET 3.5 Social Networking
Credits
Icon
Credits
About the Author
Icon
About the Author
About the Reviewer
Icon
About the Reviewer
Preface
Icon
Preface
Lock Free Chapter
1
Social Networking
Icon
Social Networking
Icon
What makes this topic so important
Icon
Once I have my own social network, then what?
Icon
Our social network—Fisharoo
Icon
This book's approach
Icon
Features of our social network
Icon
Summary
2
An Enterprise Approach to our Community Framework
Icon
An Enterprise Approach to our Community Framework
Icon
A layered architecture versus a non-layered architecture
Icon
Domain-driven Design
Icon
Model View Presenter pattern
Icon
Factory pattern using StructureMap
Icon
Repository pattern and LINQ
Icon
Wrappers for everything!
Icon
Error handling and logging
Icon
Summary
3
User Accounts
Icon
User Accounts
Icon
Problem
Icon
Design
Icon
Solution
Icon
Summary
4
User Profiles
Icon
User Profiles
Icon
Problem
Icon
Design
Icon
Solution
Icon
Summary
5
Friends
chevron up
Icon
Friends
Icon
Problem
Icon
Design
Icon
Solution
Icon
Summary
6
Messaging
Icon
Messaging
Icon
Problem
Icon
Design
Icon
Solution
Icon
Summary
7
Media Galleries
Icon
Media Galleries
Icon
Problem
Icon
Design
Icon
Solution
Icon
Summary
8
Blogs
Icon
Blogs
Icon
Problem
Icon
Design
Icon
Solution
Icon
Summary
9
Message Boards
Icon
Message Boards
Icon
Problem
Icon
Design
Icon
Categories
Icon
Solution
Icon
Summary
10
Groups
Icon
Groups
Icon
Problem
Icon
Design
Icon
Solution
Icon
Summary
11
Comments, Tags, and Ratings
Icon
Comments, Tags, and Ratings
Icon
Problem
Icon
Design
Icon
Solution
Icon
Summary
12
Moderation
Icon
Moderation
Icon
Problem
Icon
Design
Icon
Solution
Icon
Summary
13
Scaling Up
Icon
Scaling Up
Icon
Problem
Icon
Design
Icon
Solution
Icon
Summary
1
Index
Icon
Index

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...
CONTINUE READING
83
Tech Concepts
36
Programming languages
73
Tech Tools
Icon Unlimited access to the largest independent learning library in tech of over 8,000 expert-authored tech books and videos.
Icon Innovative learning tools, including AI book assistants, code context explainers, and text-to-speech.
Icon 50+ new titles added per month and exclusive early access to books as they are being written.
ASP.NET 3.5 Social Networking
End of Section 5
Next Section
notes
bookmark Notes and Bookmarks search Search in title playlist Add to playlist font-size Font size

Change the font size

margin-width Margin width

Change margin width

day-mode Day/Sepia/Night Modes

Change background colour

Close icon Search
Country selected
Close icon Your notes and bookmarks

Confirmation

Modal Close icon
claim successful
Order Page Read Now

Buy this book with your credits?

Modal Close icon
Are you sure you want to buy this book with one of your credits?
Close
YES, BUY

Submit Your Feedback

Modal Close icon
Modal Close icon
Modal Close icon