Automapper ProjectTo nested object

Viewed 837

I'm trying to use the Queryable-Extensions ProjectTo method with Entity framework inside my WebApi. It works good for normal objects but when I try to use nested objects, Linq cannot translate the Map method for the nested object into a store expression.

var entity = db.tableX.where(x => x.ID == id).ProjectTo<MyDtoObject>().FirstOrDefault();

Automapping config:

CreateMap<EntityModel.tableX, MyDtoObject>()
     .ForMember(dest => dest.Id, opts => opts.MapFrom(src => src.id))
     .ForMember(dest => dest.TestObject, opts => opts.MapFrom(src => Mapper.Map<TestObject>(src)))


CreateMap<EntityModel.tableX, TestObject>()
            .ForMember(dest => dest.Id, opts => opts.MapFrom(src => src.ForeignKey1.Id));

How can I use this ProjectTo() method with a nested object? I know other solutions with a normal Select statement, or mapping from a query into memory list, will also work..

0 Answers
Related