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