Roles - silverfoxy/PersianPortal-MVC GitHub Wiki
Roles are based on IdentityRole class from ASP.net Identity. Title field is added as Role class which inherits from IdentityRole. Title field contains persian representation of the Role. "Administrator".Title = "مدیر سایت"
Use the following query:
SELECT AspNetUsers.UserName, AspNetRoles.Name AS 'Role', AspNetRoles.Title
FROM AspNetRoles JOIN
AspNetUserRoles ON AspNetRoles.Id = AspNetUserRoles.RoleId JOIN
AspNetUsers ON AspNetUserRoles.UserId = AspNetUsers.Id