Use Contains in an integer field in C # with lambda or LINQ

Question

Navigation

#1 by (2 votes)

3

I have the following expression:

 query = query.Where(x => x.MeuCampoInteiro.ToString().Contains(filter));

But an exception is occurring:

 System.NotSupportedException: 'The expression [10008].MeuCampoInteiro.ToString() is not supported.'

Is there any way to do ToString() or Contains() in an integer field in the expression lambda ?

c# .net linq

asked by anonymous 27.09.2017 / 16:43

1 answer

How to add div before another div with JavaScript Log Storage / Indexing Tools

score 2 · Accepted Answer

Try:

query = query.Where(x => Convert.ToString(x.MeuCampoInteiro).Contains(filter));

If it does not, use:

query = query.Where(x => SqlFunctions.StringConvert(x.MeuCampoInteiro).Contains(filter));