The LINQ expression node type 'ArrayIndex' is not supported in LINQ to Entities.

Question

i have the folloiwng code inside my asp.net mvc application:-

    var result = from userContactInfo in entities.AaaUserContactInfoes
                 join contactInfo in entities.AaaContactInfoes on userContactInfo.CONTACTINFO_ID equals contactInfo.CONTACTINFO_ID

                                          where organizationNames.Any(orgName => contactInfo.EMAILID.Split('@')[1].Split('.')[0].Contains(orgName))
                 select userContactInfo;

But i am getting the following error:-

The LINQ expression node type 'ArrayIndex' is not supported in LINQ to Entities.

So what might be causing this error?

This might help: http://stackoverflow.com/questions/8353948/the-linq-expression-node-type-arrayindex-is-not-supported-in-linq-to-entities — sgeddes, Jan 04 '13 at 01:58
thanks for the reply, but i am not sure where i should apply PresId in my code?? — John John, Jan 04 '13 at 02:52

score 4 · Accepted Answer · answered Jan 04 '13 at 03:22

As stated in the comments, you can't use an array when constructing an EF query. To solve this, I would recommend trying the following trickery in your where clause:

where organizationNames.Any(orgName => contactInfo.EMAILID.Contains("@" + orgName + "."))

The LINQ expression node type 'ArrayIndex' is not supported in LINQ to Entities.

1 Answers1