Invalid 'where' condition. An entity member is invoking an invalid property or method

(0) Share

Report

Posted on by Khaled Rimawi

145

Hi , i'm trying to perform the following query which gets incident records with a specific subject, but an exception occurs : Invalid 'where' condition. An entity member is invoking an invalid property or method.

Query:

 var cases = (from incident in serviceContext.IncidentSet
                where incident.SubjectId.Id.ToString().Equals("952f3039-bdf0-e811-a970-000d3a26cab0") // if the subject is "change email request"
                select incident).ToList();

Categories:

Customization / Solutions / SDK and API

All responses (2)

Answers (0)

Khaled Rimawi 145 on at

Like (0)

Report

RE: Invalid 'where' condition. An entity member is invoking an invalid property or method

nope, not working. Casting GUID to string doesn't work in the first suggested solution. The second one is actually the same as my query but in another fashion.
Clem 2,541 on at

Like (0)

Report
RE: Invalid 'where' condition. An entity member is invoking an invalid property or method

This solution might seems stupid but try that way :

var cases = (from incident in serviceContext.IncidentSet where (string)incident.SubjectId.Id == "952f3039-bdf0-e811-a970-000d3a26cab0" // if the subject is "change email request" select incident).ToList();

Or try with Linq expression in this format :

var cases = serviceContext.IncidentSet .Where(x => x.SubjectId.Id.ToString().Equals("952f3039-bdf0-e811-a970-000d3a26cab0") // if the subject is "change email request" .Select(x).ToList();

Clément