[ProjectTo] How to configure many-to-many relation?

[MDzyga]

Source/destination types

public class RoleGroupEntity {
  public string ClientId { get; set; }
  public virtual ICollection<RoleEntity> Roles { get; set; }
  public virtual ICollection<UserEntity> Users { get; set; }
}

public class RoleEntity {
  public virtual ICollection<RoleGroupEntity> RoleGroups { get; set; }
}

public class UserEntity {
  public int Id { get; set; }
}

var roleGroups = await dbContext
   .Set<RoleGroupEntity>()
   .Where(x =>x.ClientId == client.ClientId && x.Users.Any(u => u.Id == userId))
   .ProjectTo<RoleGroup>(Mapper.ConfigurationProvider)
   .ToListAsync()

Mapping configuration

CreateMap<RoleGroupEntity, RoleGroup>();
CreateMap<RoleEntity, Role>()

Version: x.y.z

AutoMapper 10.1.1
AutoMapper.Extension.DependencyInjection 8.1.1
Microsoft.EntityFrameworkCore 5.0.11
Microsoft.EntityFrameworkCore.Sqlite.Core 5.0.11

Expected behavior

Query should be correctly translated. I notice if I map data without ProjectTo, it works.

Actual behavior

The LINQ expression 'dtoRole' could not be translated

Steps to reproduce

1. Insert rows with relation between Role and RoleGroup to database
2. Try to get data using ProjectTo

[MDzyga]

I solved it, we had a circular dependency in our dto models.