Asp.Net Core Automapper LINQ expression

Question

I'm currently working with ASP.NET Core and I want to use Automapper to map a Linq Expression. The mapping statement is:

var targetConditions = _mapper.Map<Expression<Func<Entity, bool>>>(filter);

where filter is a formal parameter in the form:

(Expression<Func<EntityDTO, bool>> filter

In the mapping profile I have the following map created:

CreateMap<Expression<Func<EntityDTO, bool>>, Expression<Func<Entity, bool>>>();

I'm using a generic repository pattern with EF. I want to get a list of DTOs filtered by, of course, DTO's fields from my controller. I then need to convert from DTO filter to entities filter in the Business Layer before doing any query using Linq for EF.

Even though the expression does get coverted from EntityDTO to Entity, the parameters in the lambda expressions inside don't, raising all sorts of errors when I further use it with EF. Any idea how can this be done?

Did you have a map for CreateMap<EntityDTO, Entity>();?

Win
– Win

2017-06-29 19:15:43 +00:00
Commented Jun 29, 2017 at 19:15 — Win
– Win, Commented Jun 29, 2017 at 19:15
@Win. Yes, I do have it

alexvilla
– alexvilla

2017-06-29 20:46:27 +00:00
Commented Jun 29, 2017 at 20:46 — alexvilla
– alexvilla, Commented Jun 29, 2017 at 20:46
How do you use it? Could you create mcve?

Win
– Win

2017-06-29 21:36:39 +00:00
Commented Jun 29, 2017 at 21:36 — Win
– Win, Commented Jun 29, 2017 at 21:36

Yaser Moradi · Accepted Answer · 2017-06-29 19:13:03Z

2

Try this:

IQueryable<Customer> query = repository.getCustomers(); // entities query
query.ProjectTo<CustomerDto>().Where(dtoFilterExpression)

answered Jun 29, 2017 at 19:13

Yaser Moradi

3,3373 gold badges26 silver badges51 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Mardoxx Over a year ago

That needs automapper ef extensions.

Yaser Moradi Over a year ago

That needs IQueryableExtensions and works with any IQueryable, including entity framework ones. What's a problem here?

alexvilla Over a year ago

Thanks @YaserMoradi. That was it! I saw that solution before but I couldn't make it work for some reason. Thanks again!

Collectives™ on Stack Overflow

Asp.Net Core Automapper LINQ expression

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related