We were writing a LINQ query to get the contract record information by passing in the lawyer name. The lawyer is a lookup in the contract record.
So we were using contract.lawyerid.Name field of lookup in our where condition.
However we got the below error while doing so..
It seems like the LINQ Implementation for CRM doesn’t correctly interpret the lookup field’s name if we are using it in the where clause.
The solution was to do a join between the entities and then use the where condition against the lawyer entity username field itself.
Hope it helps..