User Accounts | ASP.NET 3.5 Social Networking

Solution

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.

EmailVerified	This is a bit flag to let us know if a user's email address has been verified or not.
CreateDate	This is the date on which the record was created. It has a default value of `GetDate()`.
LastUpdateDate	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.
Timestamp	As stated before, LINQ requires us to have a Timestamp so that we can easily use the `Attach()` method for persisting...

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 Accounts 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 Accounts 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