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

Question

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 the ToString() or Contains() in an entire field in the expression lambda?

Answer 1

Try:

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

If not, use:

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

I put in the Github for future reference.

Documentation.

The title question does not make much sense.

Answer 2

query. Where(x => x.campoInteiro.Tostring(). Contains(campoPesquisa))