C#•2y ago

❔ AutoMapper Mapping Profiles Configuration

Hello, I'm trying to obtain the "Groups" with the users included. I'm however experiencing various Auto Mapper-related issues. GetGroupsAsync

public class GetGroupsAsync
{
    public class GroupsAsyncQuery : IRequest<IEnumerable<GroupsAsyncQueryResult>> {}

    public class GroupsAsyncQueryResult
    {
        public Guid Id
        {
            get;
            set;
        }

        public string GroupCode
        {
            get;
            set;
        }

        public string GroupName
        {
            get;
            set;
        }
        public IReadOnlyList<GetUsersAsync.UsersAsyncQueryResult> Users
        {
            get;
            set;
        }

    }
    public class Handler : IRequestHandler<GroupsAsyncQuery, IEnumerable<GroupsAsyncQueryResult>>
    {
        private readonly IMapper _mapper;
        private readonly DataContext _dataContext;

        public Handler(IMapper mapper, DataContext dataContext)
        {
            _mapper = mapper;
            _dataContext = dataContext;
        }

        public async Task<IEnumerable<GroupsAsyncQueryResult>> Handle(GroupsAsyncQuery request,
            CancellationToken cancellationToken)
        {
            var groups = await _dataContext.Groups
                .Include(x => x.UsersCollection)
                .ToListAsync(cancellationToken);
            if (groups == null)
            {
                throw new NoGroupsFoundExceptions();
            }

            var result = _mapper.Map<IEnumerable<GroupsAsyncQueryResult>>(groups);
            return result;
        }
    }
   
}

public class GetGroupsAsync
{
    public class GroupsAsyncQuery : IRequest<IEnumerable<GroupsAsyncQueryResult>> {}

    public class GroupsAsyncQueryResult
    {
        public Guid Id
        {
            get;
            set;
        }

        public string GroupCode
        {
            get;
            set;
        }

        public string GroupName
        {
            get;
            set;
        }
        public IReadOnlyList<GetUsersAsync.UsersAsyncQueryResult> Users
        {
            get;
            set;
        }

    }
    public class Handler : IRequestHandler<GroupsAsyncQuery, IEnumerable<GroupsAsyncQueryResult>>
    {
        private readonly IMapper _mapper;
        private readonly DataContext _dataContext;

        public Handler(IMapper mapper, DataContext dataContext)
        {
            _mapper = mapper;
            _dataContext = dataContext;
        }

        public async Task<IEnumerable<GroupsAsyncQueryResult>> Handle(GroupsAsyncQuery request,
            CancellationToken cancellationToken)
        {
            var groups = await _dataContext.Groups
                .Include(x => x.UsersCollection)
                .ToListAsync(cancellationToken);
            if (groups == null)
            {
                throw new NoGroupsFoundExceptions();
            }

            var result = _mapper.Map<IEnumerable<GroupsAsyncQueryResult>>(groups);
            return result;
        }
    }
   
}

Any help we much appreciated. Thanks

28 Replies

_vegabyte_OP•2y ago

Groups

public class Groups
{
    [Column("GroupId")]
    public Guid Id
    {
        get;
        set;
    }

    public string GroupCode
    {
        get;
        set;
    }

    public string GroupName
    {
        get;
        set;
    }
    [DataType(DataType.Date)]
    public DateTime DateAdded
    {
        get;
        set;
    }
    
    public ICollection<Users> UsersCollection
    {
        get;
        set;
    }
}

public class Groups
{
    [Column("GroupId")]
    public Guid Id
    {
        get;
        set;
    }

    public string GroupCode
    {
        get;
        set;
    }

    public string GroupName
    {
        get;
        set;
    }
    [DataType(DataType.Date)]
    public DateTime DateAdded
    {
        get;
        set;
    }
    
    public ICollection<Users> UsersCollection
    {
        get;
        set;
    }
}

Users

public class Users
{
    [Column("UserId")]
    public Guid Id
    {
        get;
        set;
    }

    public string UserCode
    {
        get;
        set;
    }

    public string FullName
    {
        get;
        set;
    }

    public string UserName
    {
        get;
        set;
    }

    public string Password
    {
        get;
        set;
    }

    public Guid GroupId
    {
        get;
        set;
    }
    public Groups Group
    {
        get;
        set;
    }
}

public class Users
{
    [Column("UserId")]
    public Guid Id
    {
        get;
        set;
    }

    public string UserCode
    {
        get;
        set;
    }

    public string FullName
    {
        get;
        set;
    }

    public string UserName
    {
        get;
        set;
    }

    public string Password
    {
        get;
        set;
    }

    public Guid GroupId
    {
        get;
        set;
    }
    public Groups Group
    {
        get;
        set;
    }
}

Mapping Profiles

public MapperProfiles()
    {
        CreateMap<Groups, GetGroupsAsync.GroupsAsyncQueryResult>()
            .ForMember(dest => dest.Id, opt => opt.MapFrom(src => src.UsersCollection.Select(x => x.FullName)));
    }

public MapperProfiles()
    {
        CreateMap<Groups, GetGroupsAsync.GroupsAsyncQueryResult>()
            .ForMember(dest => dest.Id, opt => opt.MapFrom(src => src.UsersCollection.Select(x => x.FullName)));
    }

Error

"Error mapping types.\r\n\r\nMapping types:\r\nList`1 -> IEnumerable`1\r\nSystem.Collections.Generic.List`1[[MineralWaterMonitoring.Domain.Groups, MineralWaterMonitoring, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null]] -> System.Collections.Generic.IEnumerable`1[[MineralWaterMonitoring.Features.Group.GetGroupsAsync+GroupsAsyncQueryResult, MineralWaterMonitoring, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null]]"

"Error mapping types.\r\n\r\nMapping types:\r\nList`1 -> IEnumerable`1\r\nSystem.Collections.Generic.List`1[[MineralWaterMonitoring.Domain.Groups, MineralWaterMonitoring, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null]] -> System.Collections.Generic.IEnumerable`1[[MineralWaterMonitoring.Features.Group.GetGroupsAsync+GroupsAsyncQueryResult, MineralWaterMonitoring, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null]]"

M B V R K•2y ago

I want to provide a help but i just get confused, why did you named that class with Groups I mean why you don't name it to Group ?

_vegabyte_OP•2y ago

Sorry for the confusion. My IDE just recommend it maybe I'll change it later. Your help is much appreciated

M B V R K•2y ago

Well I think I get the issue you need to change this

CreateMap<Groups, GetGroupsAsync.GroupsAsyncQueryResult>()

CreateMap<Groups, GetGroupsAsync.GroupsAsyncQueryResult>()

CreateMap<Groups, IEnumerable<GetGroupsAsync.GroupsAsyncQueryResult>>()

CreateMap<Groups, IEnumerable<GetGroupsAsync.GroupsAsyncQueryResult>>()

_vegabyte_OP•2y ago

Unfortunate still getting the issue

 "Error mapping types.\r\n\r\nMapping types:\r\nList`1 -> IEnumerable`1\r\nSystem.Collections.Generic.List`1[[MineralWaterMonitoring.Domain.Groups, MineralWaterMonitoring, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null]] -> System.Collections.Generic.IEnumerable`1[[MineralWaterMonitoring.Features.Group.GetGroupsAsync+GroupsAsyncQueryResult, MineralWaterMonitoring, 
Version=1.0.0.0, Culture=neutral, PublicKeyToken=null]]"

 "Error mapping types.\r\n\r\nMapping types:\r\nList`1 -> IEnumerable`1\r\nSystem.Collections.Generic.List`1[[MineralWaterMonitoring.Domain.Groups, MineralWaterMonitoring, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null]] -> System.Collections.Generic.IEnumerable`1[[MineralWaterMonitoring.Features.Group.GetGroupsAsync+GroupsAsyncQueryResult, MineralWaterMonitoring, 
Version=1.0.0.0, Culture=neutral, PublicKeyToken=null]]"

M B V R K•2y ago

Did you rebuilt your project, try it and let me know if it get fixed

_vegabyte_OP•2y ago

yes I'll already rebuilt the project but still getting the error

M B V R K•2y ago

Is Domain a spearated project ??

_vegabyte_OP•2y ago

No its on the same project Domain is a Folder containing my Entities

_vegabyte_OP•2y ago

https://github.com/aldrin0408av/MineralWaterMonitoringSystem

GitHub

GitHub - aldrin0408av/MineralWaterMonitoringSystem

Contribute to aldrin0408av/MineralWaterMonitoringSystem development by creating an account on GitHub.

M B V R K•2y ago

Please give me a bit of time, I'm trying to investigate about the issue in your code

_vegabyte_OP•2y ago

Sure Sir, Take your time. Thank you!

M B V R K•2y ago

First of you need to change the

 CreateMap<Groups, GetGroupsAsync.GroupsAsyncQuery>()

 CreateMap<Groups, GetGroupsAsync.GroupsAsyncQuery>()

CreateMap<Groups, GetGroupsAsync.GroupsAsyncQueryResult>()

CreateMap<Groups, GetGroupsAsync.GroupsAsyncQueryResult>()

But you will still get a runtime error : because of the Id in GroupsAsyncQueryResult is Guidand the FullName in Users is string Can you just tell me what you want to do in the MappingProfile ??

_vegabyte_OP•2y ago

I want the result would be like this { "success": true, "data": [ { "id": "780c5114-4e55-4878-0218-08db6648b3a6", "groupCode": "3FCOR", "groupName": "3rd Floor Corporate", "users": [] } ], "messages": [] } I want to get the groups including the user in that group

M B V R K•2y ago

Alright the GroupsAsyncQueryResult 's Users should be lke this :

        public ICollection<Domain.Users> Users
        {
            get;
            set;
        }

        public ICollection<Domain.Users> Users
        {
            get;
            set;
        }

Then the mapping should be :

        CreateMap<Groups, GetGroupsAsync.GroupsAsyncQueryResult>()
            .ForMember(dest => dest.Users, opt => opt.MapFrom(src => src.UsersCollection));

        CreateMap<Groups, GetGroupsAsync.GroupsAsyncQueryResult>()
            .ForMember(dest => dest.Users, opt => opt.MapFrom(src => src.UsersCollection));

M B V R K•2y ago

This is the version of your project that I modified

MineralWaterMonitori...

M B V R K•2y ago

Let me know if you the issue get fixed and the goal get achieved

_vegabyte_OP•2y ago

The error is fixed and this is the output.

{
  "success": true,
  "data": [
    {
      "id": "780c5114-4e55-4878-0218-08db6648b3a6",
      "groupCode": "3FCOR",
      "groupName": "3rd Floor Corporate",
      "users": [
        {
          "id": "a59c1fbe-cf73-4052-c442-08db6648ebd6",
          "userCode": null,
          "fullName": "Aldrin Vega",
          "userName": "Aldrin",
          "password": "Vega",
          "groupId": "780c5114-4e55-4878-0218-08db6648b3a6",
          "group": {
            "id": "780c5114-4e55-4878-0218-08db6648b3a6",
            "groupCode": "3FCOR",
            "groupName": "3rd Floor Corporate",
            "dateAdded": "0001-01-01T00:00:00",
            "usersCollection": [
              null,
              {
           "id": "83bfc054-1021-4204-d9e8-08db6649b9bb",
                "userCode": null,
                "fullName": "Aldrin Vega",
                "userName": "Minari",
                "password": "Aldrin004",
                "groupId": "780c5114-4e55-4878-0218-08db6648b3a6",
                "group": null
              }
            ]
          }
        },
        {
          "id": "83bfc054-1021-4204-d9e8-08db6649b9bb",
          "userCode": null,
          "fullName": "Aldrin Vega",
          "userName": "Minari",
          "password": "Aldrin004",
          "groupId": "780c5114-4e55-4878-0218-08db6648b3a6",
          "group": {
            "id": "780c5114-4e55-4878-0218-08db6648b3a6",
            "groupCode": "3FCOR",
            "groupName": "3rd Floor Corporate",
            "dateAdded": "0001-01-01T00:00:00",
            "usersCollection": [
              {
                "id": "a59c1fbe-cf73-4052-c442-08db6648ebd6",
                "userCode": null,
                "fullName": "Aldrin Vega",
                "userName": "Aldrin",
                "password": "Vega",
                "groupId": "780c5114-4e55-4878-0218-08db6648b3a6",
                "group": null
              },
              null
            ]
          }
        }
      ]
    }
  ],
}

{
  "success": true,
  "data": [
    {
      "id": "780c5114-4e55-4878-0218-08db6648b3a6",
      "groupCode": "3FCOR",
      "groupName": "3rd Floor Corporate",
      "users": [
        {
          "id": "a59c1fbe-cf73-4052-c442-08db6648ebd6",
          "userCode": null,
          "fullName": "Aldrin Vega",
          "userName": "Aldrin",
          "password": "Vega",
          "groupId": "780c5114-4e55-4878-0218-08db6648b3a6",
          "group": {
            "id": "780c5114-4e55-4878-0218-08db6648b3a6",
            "groupCode": "3FCOR",
            "groupName": "3rd Floor Corporate",
            "dateAdded": "0001-01-01T00:00:00",
            "usersCollection": [
              null,
              {
           "id": "83bfc054-1021-4204-d9e8-08db6649b9bb",
                "userCode": null,
                "fullName": "Aldrin Vega",
                "userName": "Minari",
                "password": "Aldrin004",
                "groupId": "780c5114-4e55-4878-0218-08db6648b3a6",
                "group": null
              }
            ]
          }
        },
        {
          "id": "83bfc054-1021-4204-d9e8-08db6649b9bb",
          "userCode": null,
          "fullName": "Aldrin Vega",
          "userName": "Minari",
          "password": "Aldrin004",
          "groupId": "780c5114-4e55-4878-0218-08db6648b3a6",
          "group": {
            "id": "780c5114-4e55-4878-0218-08db6648b3a6",
            "groupCode": "3FCOR",
            "groupName": "3rd Floor Corporate",
            "dateAdded": "0001-01-01T00:00:00",
            "usersCollection": [
              {
                "id": "a59c1fbe-cf73-4052-c442-08db6648ebd6",
                "userCode": null,
                "fullName": "Aldrin Vega",
                "userName": "Aldrin",
                "password": "Vega",
                "groupId": "780c5114-4e55-4878-0218-08db6648b3a6",
                "group": null
              },
              null
            ]
          }
        }
      ]
    }
  ],
}

I want to get the user will be the Name only is that possible?

M B V R K•2y ago

So you want to get all Groups and every group should include the Name of the user ???

_vegabyte_OP•2y ago

Yes Sir,

M B V R K•2y ago

hmmm, give me a bit of time I will change somethings in your project

_vegabyte_OP•2y ago

Okay sir, Thanks

M B V R K•2y ago

I did a bit change in your code, you can take a look at it here an tell me if this good for design you follow? and is it works ?

MineralWaterMonitori...

_vegabyte_OP•2y ago

Sir i get some error

{
  "success": false,
  "data": null,
  "messages": [
    "Exception has been thrown by the target of an invocation."
  ]
}

{
  "success": false,
  "data": null,
  "messages": [
    "Exception has been thrown by the target of an invocation."
  ]
}

M B V R K•2y ago

Can you start the project in debug mode and do a screenshot to the Exception ?

_vegabyte_OP•2y ago

_vegabyte_OP•2y ago

Expression 'dest => dest.User.FullName' must resolve to top-level member and not any child object's properties. You can use ForPath, a custom resolver on the child type or the AfterMap option instead. (Parameter 'lambdaExpression')

Expression 'dest => dest.User.FullName' must resolve to top-level member and not any child object's properties. You can use ForPath, a custom resolver on the child type or the AfterMap option instead. (Parameter 'lambdaExpression')

Hi, just tweaking the code and it works as expected Thank You for your help

Accord•2y ago

Was this issue resolved? If so, run /close - otherwise I will mark this as stale and this post will be archived until there is new activity.

Gaming

Programming

❔ AutoMapper Mapping Profiles Configuration

Did you find this page helpful?