How to display the number of site users who are authorized through a specific social network in ASP.NET?

Question

ASP.NET

There is an ASP.NET web application with built-in authorization, where you can add authorization through social networks (facebook, google, VK).
I need to build a diagram of how many users are registered through facebook, how many through google, and so on, and for this I need to somehow display at least the number of these people.
Tell me how can this be done?

UPD: I noticed that there is a Facebook line in the "AspNetUserLogins" table, how can I get information from it?
UPD2: I know that I need to take information from the table, my question is how to do it so that it is on the site

Answer 1

Can be solved with SQL.
In the table AspNetUserLogins You do grouping on LoginProvider and you consider kol-in records in each group.

Answer 2

see https: //hamidmosalla.com/2016/02/23/how-to-show-cu
...
core needs a bit of redoing