Skip to content

Instantly share code, notes, and snippets.

Created May 15, 2020
What would you like to do?
SELECT [a].[Id] AS [UserId], [a].[UserName], [a1].[Id] AS [RoleId], [a1].[Name] AS [RoleName]
FROM [AspNetUsers] AS [a]
INNER JOIN [AspNetUserRoles] AS [a0] ON [a].[Id] = [a0].[UserId]
INNER JOIN [AspNetRoles] AS [a1] ON [a0].[RoleId] = [a1].[Id]
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment