如何向AutoMapper传递额外数据？EF Core注入数据库查询方案

一、动态传入Rank字典完成映射 #

要避免把Rank字典硬编码到AutoMapper配置中，可通过AutoMapper的映射上下文传递动态参数，具体实现如下：

1. 配置AutoMapper Profile #

public class StudentProfile : Profile
{
    public StudentProfile()
    {
        CreateMap<Student, StudentRankingDto>()
            // 拼接姓名
            .ForMember(dest => dest.Name, opt => opt.MapFrom(src => $"{src.FirstName} {src.LastName}"))
            // 从上下文获取动态传入的字典，匹配Rank
            .ForMember(dest => dest.Rank, opt => opt.MapFrom((src, _, __, context) => 
            {
                var rankDict = context.Items["RankDictionary"] as Dictionary<byte, string>;
                return rankDict?.TryGetValue(src.Score, out var rank) ?? false ? rank : "unknown";
            }));
    }
}

2. 映射时传入字典 #

// 初始化业务侧的Rank字典（可从配置/其他服务获取）
var rankingDict = new Dictionary<byte, string>() 
{
    {0,"rejected" },
    {1,"very weak" },
    {2,"very weak" },
    {3,"weak" },
    {4,"weak" },
    {5,"medium" },
    {6,"medium" },
    {7,"Good" },
    {8,"Good" },
    {9,"Excellent" },
    {10,"Excellent" }
};

// 映射时通过Options传入字典到上下文
var students = _dbContext.Students.ToList();
var dtos = _mapper.Map<List<StudentRankingDto>>(students, opt => 
{
    opt.Items["RankDictionary"] = rankingDict;
});

二、EF Core数据注入到AutoMapper的解决方法 #

如果Rank规则存储在数据库表中，可通过依赖注入将EF Core上下文（或封装的服务）注入到AutoMapper Profile中，解决官方指南传递失败的问题：

1. 数据库实体与服务封装（可选，优化性能） #

假设数据库有RankSettings表，先定义实体：

public class RankSetting
{
    public byte Score { get; set; }
    public string RankName { get; set; }
}

封装缓存服务避免重复查库：

public interface IRankService
{
    Dictionary<byte, string> GetRankDictionary();
}

public class RankService : IRankService
{
    private readonly AppDbContext _dbContext;
    private Dictionary<byte, string> _rankCache;

    public RankService(AppDbContext dbContext)
    {
        _dbContext = dbContext;
    }

    public Dictionary<byte, string> GetRankDictionary()
    {
        if (_rankCache == null)
        {
            _rankCache = _dbContext.RankSettings.ToDictionary(r => r.Score, r => r.RankName);
        }
        return _rankCache;
    }
}

2. 注入服务到AutoMapper Profile #

public class StudentProfile : Profile
{
    private readonly IRankService _rankService;

    // 通过DI注入服务（AutoMapper会自动从容器获取依赖）
    public StudentProfile(IRankService rankService)
    {
        _rankService = rankService;

        CreateMap<Student, StudentRankingDto>()
            .ForMember(dest => dest.Name, opt => opt.MapFrom(src => $"{src.FirstName} {src.LastName}"))
            .ForMember(dest => dest.Rank, opt => opt.MapFrom(src => 
            {
                var rankDict = _rankService.GetRankDictionary();
                return rankDict.TryGetValue(src.Score, out var rank) ? rank : "unknown";
            }));
    }
}

3. 注册DI服务 #

在Program.cs（或Startup）中完成服务注册：

// 注册EF Core上下文
builder.Services.AddDbContext<AppDbContext>(options => 
    options.UseSqlServer(builder.Configuration.GetConnectionString("DefaultConnection")));

// 注册Rank服务
builder.Services.AddScoped<IRankService, RankService>();

// 注册AutoMapper，扫描当前程序集的Profile
builder.Services.AddAutoMapper(typeof(Program));

关键注意点 #

• 不要在Profile中使用静态DB上下文或硬编码数据，必须通过构造函数注入依赖，确保AutoMapper能从DI容器获取实例
• 若直接注入DB上下文到Profile，注意每次映射都会触发数据库查询，建议加缓存避免性能损耗

内容的提问来源于stack exchange，提问作者ROMO