LINQ expression could not be translated #8582

6 Answer(s)

• 

  0

  maliming created 5 years ago

  Support Team

  hi

  Please share your query code.

  eg

  .Where(r => r.InvoiceNumber.ToString().Contains(__input_Filter_0)
  

  Save Cancel
• 

  0

  alfar_re created 5 years ago

  Here you go. That's the entire code block.

  var query = _lookup_rentalInvoiceRepository.GetAll().WhereIf(
  		!string.IsNullOrWhiteSpace(input.Filter),
  	   e=> e.InvoiceNumber.ToString().Contains(input.Filter)
  	);
  
  var totalCount = await query.CountAsync();
  
  var rentalInvoiceList = await query
  	.PageBy(input)
  	.ToListAsync();
  
  var lookupTableDtoList = new List();
  foreach(var rentalInvoice in rentalInvoiceList){
  	lookupTableDtoList.Add(new TransactionRentalInvoiceLookupTableDto
  	{
  		Id = rentalInvoice.Id,
  		DisplayName = string.Format(rentalInvoice.InvoiceNumber?.ToString(), " - ", rentalInvoice.Description, "(", rentalInvoice.Status, ")")
  	});
  }
  
  return new PagedResultDto(
  	totalCount,
  	lookupTableDtoList
  );
  

  Save Cancel
• 

  0

  maliming created 5 years ago

  Support Team

  hi
  It looks like InvoiceNumber is not a string and ef core cannot translate the ToString method.

  Save Cancel
• 

  0

  alfar_re created 5 years ago

  Hi,

  InvoiceNumber is actually a string. And the same issue is occuring in almost all look up tables.

  Save Cancel
• 

  0

  maliming created 5 years ago

  Support Team

  • What is your product version?

  • What is your abp framework version?

  InvoiceNumber is actually a string

  Did you try removing the ToString() method?

  var query = _lookup_rentalInvoiceRepository.GetAll().WhereIf(
  		!string.IsNullOrWhiteSpace(input.Filter),
  	   e=> e.InvoiceNumber.Contains(input.Filter)
  	);
  

  Save Cancel
• 

  0

  alfar_re created 5 years ago

  Hi,

  I actually changed all filter methods and removed the ToString()where the property was a string and it worked well.

  Allow me to close this now. Many thanks for the help. Cheers!

  Save Cancel