I'm using automapper for a dynamic query and it's working well until I use an orderby clause. So this is how I create the query:
IQueryable<DTOFormCellSouches> query;
//Configuration de l'automapper de l'objet BD vers le DTO
var config = new MapperConfiguration(cfg => {
cfg.CreateMap<FormCellSouch, DTOFormCellSouches>();
});
//Map des champs
var mapper = config.CreateMapper();
query = (_context.FormCellSouches).Select(a => mapper.Map<FormCellSouch, DTOFormCellSouches>(a));
return query;
Then if I have an order criteria, I add it to the querylike this:
if (orderCriteria != "")
{
if (query != null)
{
query = query.OrderBy(orderCriteria);
}
}
I get that error when adding the criteria and running the query: The LINQ expression 'DbSet() .OrderBy(f => __mapper_0.Map<FormCellSouch, DTOFormCellSouches>(f).Nom)' could not be translated. Either rewrite the query in a form that can be translated, or switch to client evaluation explicitly by inserting a call to 'AsEnumerable', 'AsAsyncEnumerable', 'ToList', or 'ToListAsync'. See /?linkid=2101038 for more information.
Since it's dynamic, it can have filter too, so there will be where clause and I'll probably have a similar problem.
I've tried to convert the query to other format has the message suggest but I can't make it work.
I'm using automapper for a dynamic query and it's working well until I use an orderby clause. So this is how I create the query:
IQueryable<DTOFormCellSouches> query;
//Configuration de l'automapper de l'objet BD vers le DTO
var config = new MapperConfiguration(cfg => {
cfg.CreateMap<FormCellSouch, DTOFormCellSouches>();
});
//Map des champs
var mapper = config.CreateMapper();
query = (_context.FormCellSouches).Select(a => mapper.Map<FormCellSouch, DTOFormCellSouches>(a));
return query;
Then if I have an order criteria, I add it to the querylike this:
if (orderCriteria != "")
{
if (query != null)
{
query = query.OrderBy(orderCriteria);
}
}
I get that error when adding the criteria and running the query: The LINQ expression 'DbSet() .OrderBy(f => __mapper_0.Map<FormCellSouch, DTOFormCellSouches>(f).Nom)' could not be translated. Either rewrite the query in a form that can be translated, or switch to client evaluation explicitly by inserting a call to 'AsEnumerable', 'AsAsyncEnumerable', 'ToList', or 'ToListAsync'. See https://go.microsoft.com/fwlink/?linkid=2101038 for more information.
Since it's dynamic, it can have filter too, so there will be where clause and I'll probably have a similar problem.
I've tried to convert the query to other format has the message suggest but I can't make it work.
I found a way, just adding ToList().AsQueryable(), resolved the issue:
I change my query line with the following: query = (_context.FormCellSouches).Select(a => mapper.Map<FormCellSouch, DTOFormCellSouches>(a)).ToList().AsQueryable();