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

(0) Share

Report

Posted on by Community Member Microsoft Employee

Hello guys,

I need to do a SELECT in Linq C#, but don't work. My code:

                var name = "aa"

                var listAccounts = (from i in contexto.ContextoServico.AccountSet
                                    where 
                                    name.ToUpper().Contains(i.ojc_name.ToUpper())
                                    orderby i.ojc_name ascending
                                    select i).Take(10).ToList();

Can you help me ?

*This post is locked for comments

All responses (2)

Answers (0)

Community Member Microsoft Employee on at

Like (0)

Report

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

Hi Mahadeo,

Thank you very much for answer ...

I solved maked it:

var listAccounts = (from i in contexto.ContextoServico.AccountSet

where (i.StateCode == AccountState.Active && (i.ojc_name.Contains(nome.ToLower()) || i.ojc_accountnumber.Contains(nome)))

orderby i.ojc_name ascending

select i).Take(qtd.Value).ToList();

We can'not to set ToUpper() in the property field of CRM. Only in variable of parameter.
Suggested answer

Mahadeo Matre 17,021 on at

Like (0)

Report

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

Hi..

i think you need to change query like

var name = "aa"

var listAccounts = (from i in contexto.ContextoServico.AccountSet

where

i.ojc_name.ToUpper().Contains(name.ToUpper())

orderby i.ojc_name ascending

select i).Take(10).ToList();