How to Get User List with Role From IdentityUser using .net core and AutoMapper
Hi I want to Get the Identity User List with Role using .NET core and Auto Mapper (Create Map)
Each User Have Only one Role, I want to Return the List With Each User Role, I am Using Auto Mapper To Map
This is the List I want to be Generated
| Display Name | User Name | Email | Role | Department |
|:------------:|:---------:|:------------------:|:-----:|:--------------:|
| Admin | Admin123 | [email protected] | Admin | System Defined |
This is the Query
public async Task<Result<PagedList<AppUserDto>>> Handle(Query request, CancellationToken cancellationToken)
{
var query = _context.Users.
OrderByDescending(d => d.Id).ProjectTo<AppUserDto>(_mapper.ConfigurationProvider)
.AsQueryable();
return Result<PagedList<AppUserDto>>.Success(
await PagedList<AppUserDto>.CreateAsync(query, request.Params.PageNumber, request.Params.PageSize)
);
}
public class AppUserDto
{
public string Id { get; set; }
public string DisplayName { get; set; }
public string UserName { get; set; }
public string Email { get; set; }
public string DepartmentNameE { get; set; }
public string RoleId { get; set; }
public string RoleName { get; set; }
}
Mapping
CreateMap<AppUser, AppUserDto>()
.ForMember(d => d.DepartmentNameE, o => o.MapFrom(s => s.FDSDepartments.DepartmentNameE));
App User Class
public class AppUser : IdentityUser
{
public string DisplayName { get; set; }
public int DepartmentID { get; set; }
public virtual FDSDepartments FDSDepartments { get; set; }
}