18

How can I get the logged in user's UserId? I'm using the standard system generated AccountModel. I can get the username using:

User.Identity.Name

but I don't see the UserId field. I want to use the UserId as a foreign key for another table.

Erik Philips
  • 53,428
  • 11
  • 128
  • 150
naveed
  • 1,395
  • 2
  • 15
  • 29

4 Answers4

26

Try this:

using Microsoft.AspNet.Identity;
User.Identity.GetUserId();

That's how its done in the partial views for current MVC (MVC5/EF6/VS2013) templates.

Correct me if I'm wrong, because I've seen Aviatrix's answers a lot, but what happens if more than one user has the same name in the database?

prasanthv
  • 2,442
  • 2
  • 21
  • 17
  • This solution is not possible if the user is already logged in and trying to change the current password. – usefulBee Nov 07 '16 at 19:57
15

I think you're looking for ProviderUserKey - Gets the user identifier from the membership data source for the user.

object id = Membership.GetUser().ProviderUserKey

Membership.GetUser() - Gets the information from the data source and updates the last-activity date/time stamp for the current logged-on membership user.

Erik Philips
  • 53,428
  • 11
  • 128
  • 150
10

The best way to do so is to use the WebSecurty class

var memberId = WebSecurity.GetUserId(User.Identity.Name);

and don't forget to add [InitializeSimpleMembership] on top of your controller :)

Nikola Sivkov
  • 2,812
  • 3
  • 37
  • 63
0

Their are already very good answer but what i understood from your question is that you want to fetch data from database using id.so here is what you can do.

public List<ForeignkeyTable> RV()
{
 var email = User.Identity.Name;

Usertable m = db.Uusertables.Where(x => x.user_Email == email).SingleOrDefault();

 var id = m.user_Id;

var p = db.ForeignkeyTable.Where(x => x.user_fk_id == id).ToList();


return p;

}

This way you can return all the data from database of that id in foreignkey.

Learner
  • 1
  • 1