Details of table(s) used to store AAD authentication tokens

  • Hi

    Does anyone know the names of the SQL Server tables and their field definitions that are used to store Azure Active Directory authentication tokens?

    Are these pre-defined system tables or do I need to set these up myself?

    The article at the link below contains the following:

    "Now add a class named EFADALContext.cs into the Utils folder. This class will derive from Entity Framework’s DbContext class and handle mapping the PerWebUserCache object to the proper table in SQL Server."

    I am trying to find out the name and field definitions of this particular table in SQL Server so that I can write a SQL script to create it.

    https://weblogs.asp.net/dwahlin/adding-azure-active-directory-and-owin-code-into-an-angularjs-asp-net-mvc-application-to-handle-user-authentication

    Thanks in advance

    Tristan

  • The Table name will be like UserTokenCache. It will be generated by the system itself.

    The columns in the table are 

    UserTokenCacheId - int, not null
    webUserUniqueId - nvarchar(max),null
    cacheBits -varbinary(max),null)
    LastWrite- datetime,not null

    Hope this Helps,
    Jay

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply