LINQ to Entities does not recognize the method 'System.String ToString()' method,and this method cannot be translated into a store expression

Question

allList = allList.Where(c => isAdvertSearchable 
  && c.tblAdvert.AdvertTitle.ToLower().Trim().Contains(param.sSearch.ToLower())
  || isTranastionTypeSearchable 
  && c.IsActive.ToString().ToLower().Trim().Contains(param.sSearch.ToLower())
  || (c.Amount.ToString().ToLower().Contains(param.sSearch.ToLower().ToString()) 
  || param.sSearch == "")
  || isTranastionIDSearchable 
  && c.TransactionId.ToLower().Trim().Contains(param.sSearch.ToLower())

possible duplicate of LINQ to Entities does not recognize the method 'System.String ToString()' method, and this method cannot be translated into a store expression — GraemeMiller
– GraemeMiller, Commented Mar 2, 2015 at 13:15

Mihai Dinculescu · Accepted Answer · 2014-12-15 08:54:59Z

1

LINQ is complaining about not being able to translate ToString to T-SQL.

Use

SqlFunctions.StringConvert(param.sSearch.ToLower())

SqlFunctions Class
Provides common language runtime (CLR) methods that call functions in the database in LINQ to Entities queries.
http://msdn.microsoft.com/en-us/library/system.data.objects.sqlclient.sqlfunctions(v=vs.110).aspx

edited Dec 15, 2014 at 8:54

answered Dec 15, 2014 at 8:49

Mihai Dinculescu

20.1k8 gold badges59 silver badges70 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

LINQ to Entities does not recognize the method 'System.String ToString()' method,and this method cannot be translated into a store expression

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related