Hello,

Is it possible to apply a function on a field in a prefetch path ? :

var riskPrefetch = MaturityInvoiceEntity.PrefetchPathRiskCustomer;
riskPrefetch.ExcludedIncludedFields = new ExcludeIncludeFieldsList(false);
riskPrefetch.ExcludedIncludedFields.Add(RiskCustomerFields.LegalName); /* I'd like to trim this field */

var qf = new QueryFactory();
var q = qf.MaturityInvoice.WithPath(riskPrefetch);

In this sample, I'd like the field "LegalName" to be trim :

riskPrefetch.ExcludedIncludedFields.Add(RiskCustomerFields.LegalName.Trim());/*This code doesn't work*/

Thanks in advance, Regards, Etienne.

Do you want the trimming to be done at the database side or at the code side (after fetching)?

On server side if possible.

For the moment, I process all the entity to apply the trim after fetching.

Thanks

On server side is not possible (easily) with entity fetches. You should use projections, available on Linq2LLBL and QuerySpec. See the documentation for examples.

Ok, I'll do that, thanks for your answer