Skip to content

Instantly share code, notes, and snippets.

@gavilanch

gavilanch/query.sql

Created May 15, 2020 14:17
Show Gist options
  • Save gavilanch/218dc7379a7477c1e1c0505a89204049 to your computer and use it in GitHub Desktop.
Save gavilanch/218dc7379a7477c1e1c0505a89204049 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
query.sql
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