Book Image

ASP.NET 3.5 Social Networking

By : Andrew Siemer
Book Image

ASP.NET 3.5 Social Networking

By: Andrew Siemer

Overview of this book

Table of Contents (19 chapters)


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

Implementing the database

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

The Accounts table

The Accounts table will store all the base information for a user. Most of this is easy to figure out as they have indicative names (a sign of good design).

However, there are a few columns that may not be 100% clear at first glance. I will explain those here.


This is a bit flag to let us know if a user's email address has been verified or not.


This is the date on which the record was created. It has a default value of GetDate().


This is similar to the CreateDate with the exception that we should update it every time we update the record. This could be done with a trigger, or done programmatically.


As stated before, LINQ requires us to have a Timestamp so that we can easily use the Attach() method for persisting...