DB Storage

[jmohler1970]

Username and password is stored in db of developer’s choice.

[jmohler1970]

Db structure

I like using plurals on DB table names, because they typically have multiple rows of data. Furthermore user is a keyword in T-SQL, so I would have interact with it like

SELECT ID
FROM dbo.[user]
WHERE ID  = ?

Writing square brackets gets old.

I would have added a unique index on Email that was appropriate.