Authentication with Azure AD with SQL database sync

We are working on Asp .NET core web API. In this application right now we have implemented JWT token based authentication using Asp Net Identity, we need to make similar authentication feature using Azure AD. Also we need to sync SQL database with user details and send back tokens to front end application. Please provide any solution if any or if you have better solution?

I would recommend this link. This article is according to your requirement.

https://docs.microsoft.com/en-us/azure/active-directory/develop/tutorial-v2-asp-webapp

Only you need to save user information to sql db in this function

public ActionResult Index()
{
var userClaims = User.Identity as System.Security.Claims.ClaimsIdentity;
//You get the user's first and last name below:
ViewBag.Name = userClaims?.FindFirst("name")?.Value;
// The 'preferred_username' claim can be used for showing the username
ViewBag.Username = userClaims?.FindFirst("preferred_username")?.Value;
// The subject/ NameIdentifier claim can be used to uniquely identify the user across the web
ViewBag.Subject = userClaims?.FindFirst(System.Security.Claims.ClaimTypes.NameIdentifier)?.Value;
// TenantId is the unique Tenant Id - which represents an organization in Azure AD
ViewBag.TenantId = userClaims?.FindFirst("http://schemas.microsoft.com/identity/claims/tenantid")?.Value;
//// call you sql save function with above user details
return View();
}

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Rijwan Ansari5y ago
I would recommend this link. This article is according to your requirement.

https://docs.microsoft.com/en-us/azure/active-directory/develop/tutorial-v2-asp-webapp

Only you need to save user information to sql db in this function
public ActionResult Index()
    {
        var userClaims = User.Identity as System.Security.Claims.ClaimsIdentity;

        //You get the user's first and last name below:
        ViewBag.Name = userClaims?.FindFirst("name")?.Value;

        // The 'preferred_username' claim can be used for showing the username
        ViewBag.Username = userClaims?.FindFirst("preferred_username")?.Value;

        // The subject/ NameIdentifier claim can be used to uniquely identify the user across the web
        ViewBag.Subject = userClaims?.FindFirst(System.Security.Claims.ClaimTypes.NameIdentifier)?.Value;

        // TenantId is the unique Tenant Id - which represents an organization in Azure AD
        ViewBag.TenantId = userClaims?.FindFirst("http://schemas.microsoft.com/identity/claims/tenantid")?.Value;

//// call you sql save function with above user details

        return View();
    }
+1