Search code examples
c#.netasp.net-mvcasp.net-mvc-5asp.net-identity

Where does ASP.NET Identity store information about external authentication provider?


In my ASP.NET MVC application, I have enabled authentication using Microsoft and Google accounts. They both are working fine. i.e., I am able to login to my application using my hotmail and gmail both accounts.

Once logged in (say, using Microsoft account), I am able to see following screen as well.

enter image description here

I am able to change the password. While all this works fine, I am quite unsure where all this information is getting stored? In previous editions, I was able to see External Provider mapping tables getting created automatically in the database. However, in this instance, database has no table, which makes me believe that this mapping is getting stored somewhere else.

Can someone please shed lights on this?

P.S. - I am using SQL Server 2016 Express edition, and have no other authentication enabled for this application (i.e., there is no Forms authentication as well). Only, Google and Microsoft logins are accepted. Also, System.Web.Mvc in my application is of version - 5.2.3.0


Solution

  • They are stored in the AspNetUserLogins table.

    Asp.net Identity tables