LINQ Query Invalid Where condition Error.

(0) Share

Report

Posted on by Community Member

I have a Agent entity having 3 columns AgentGuid (PK), AgentId (not unique) and AgentName. I have a csv file have 2 columns (AgentId, AgentName) which are comma separated to be passed as filter condition.

1001,Agent1

1002,Agent2

1003,Agent3

1001,Agent4

I wrote the LINQ query like below :

var AgentIds = new List<Guid?>();
var filter = File.ReadLines(strFilePath).Select(line => line.Split(','));
AgentIds = (from a in linq.AgentSet
             where filter.Any(f => f[0] == a.AgnetID && f[1] == a.AgentName.ToString())
             select a.AgentGuid).ToList();

I thought I am done... but query is giving me exception,

Exceptions: System.NotSupportedException, "Invalid 'where' condition. An entity member is invoking an invalid property or method."

may be I am missing something please suggest.

*This post is locked for comments

I have the same question (0)

All responses (4)

Answers (0)

Suggested answer

ashlega 34,477 on at

Like (1)

Report

There are limitations in the CRM linq provider.

I don't think you can use the filter there - linq expression gets translated into a FetchXml expression which is, basically, a static XML, so, the way I understand it, you can't use that kind of conditions (filter.Any). And you probably can't use "ToString" on the attribute either (can type cast though)

Remove that where, select everything to a list, and, then, run a filter on the list..

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Thanks Alex for replying,

Please suggest the correct way to query, I have removed .ToString() from the attributes as it is not needed there.

Was this reply helpful? Yes No
Suggested answer

ashlega 34,477 on at

Like (0)

Report

Hi,

the simplest solution would be to load all agent records to a list from CRM, and, then, to filter the list:

var AgentIds = new List<Guid?>();

var filter = File.ReadLines(strFilePath).Select(line => line.Split(','));

AgentIds = (from a in linq.AgentSet

select a.AgentGuid).ToList();

<Filter the list here>

Not sure if there is a more "elegant" solution. There are some examples of the supported CRM linq queries here:

msdn.microsoft.com/.../gg334593.aspx

Was this reply helpful? Yes No
Suggested answer

NatrajY 3,040 on at

Like (0)

Report
Change

linq.AgentSet

to

linq.AgentSet.AsEnumerable()

OR use this query instead

var AgentIds = new List<Guid?>(); var agentNames = File.ReadLines(strFilePath).Select(line => line.Split(',')).Select(line => new { AgnetID = line[0], AgentName = line[1] }); AgentIds = (from n in agentNames join a in linq.AgentSet on new { n.AgnetID, n.AgentName } equals new { a.AgnetID, a.AgentName} select a.AgentGuid).ToList();

Was this reply helpful? Yes No