The AspNetUserLogins table Identity

c# asp.net-mvc entity-framework asp.net-identity
Bryan picture Bryan · Feb 2, 2016 · Viewed 16.6k times · Source

What is the AspNetUserLogins for? Is It to store the logins from the user? How can I then update this table with that data?

Answer

Preet Singh picture Preet Singh · Feb 2, 2016

What is the AspNetUserLogins for? In Asp.net Identity, the Identity system uses the AspNetUserLogins table to hold information about 3rd party/external logins, for example users who login into your site via Google, Facebook, Twitter etc. The AspNetUsers table is the primary table to store user information, this is linked to AspNetUserLogins via UserId -> AspNetUsers.Id.

For example if the user logs into your site via Facebook, then the LoginProvider is the name of the service which provided the login, so in this case "Facebook", the ProviderKey is a unique Facebook key associated with the user on Facebook.

This table is used by the Asp.net external authentication providers.

Is it to store the logins from the user? No not really, it is used as explained above

How can I then update this table with that data? You don't update the data in this table, usually when a user logs in via external provider, after user has been authenticated, the provider returns a ClaimsIdentity, which has users claims and one of those is a unique id of the user in the external provider, this gets automatically updated in this table.

read more about external providers here

Related questions

ASP.NET Identity - Multiple object sets per type are not supported

I got an error using ASP.NET Identity in my app. Multiple object sets per type are not supported. The object sets 'Identity Users' and 'Users' can both contain instances of type 'Recommendation Platform.Models.ApplicationUser'. I saw a few …

Read More
How to create SecurityStamp for AspNetUser in ASP .NET MVC 5

When I create user by Register action whe application is running the application user gets SecurityStamp. When I add user by: if (!context.Users.Any()) { System.Diagnostics.Debug.WriteLine("INSIDE"); var hasher = new PasswordHasher(); try { var users = new List<…

Read More
Why is Asp.Net Identity IdentityDbContext a Black-Box?

There is a lot of confusion it seems around IdentityDbContext. If we create two Database Contexts in our application, one for Identity and one for our custom business data, the Identity Database Context inherits from IdentityDbContext while our custom business …

Read More