Is the normal way to do this to just make 2 cols in my User table, loginCount and lastLogin, and then when a user is Authenticated hit the db and update them in the code behind?
I am using OpenID only.
Is there a better way?
Is the normal way to do this to just make 2 cols in my User table, loginCount and lastLogin, and then when a user is Authenticated hit the db and update them in the code behind?
I am using OpenID only.
Is there a better way?
Look into the asp.net membership provider it does everything for you.
I use the same solution and it works for me (and my clients, too) :)
If you have not considered Built-in Security Features for Memberships and Roles management, have a look at these tutorials. What you are about to start working on, might have already been implemented.