Problem: I'm dealing with 2 different databases,
1 - membership & roles
2 - My program database
The 1st database is the MVC4 SimpleMembershipProvider. Very simple login and very little user info stored. I know how to get the current logged-in user name like so:
string userName = HttpContext.User.Identity.Name;
The 2nd database contains actual Program data and some user info used in the actual web site for our Products inventory. It has the UserID i really need to persist for use in several controllers. Inserts, Updates, Deletes all rely on this UserID.
So the logged-in UserID or Username and Role is not the same as our actual Program database.
Q. Do need a 'translation table' to cross-reference the WebMatrix User Info to our 'Products' User Info?
I hope this post is making sense, it's a bit difficult to explain...