How convert int to string column?

Question

Where expression:

 filtrationResult = filtrationResult.Where(string.Format("Convert.ToString({0}).Contains(@0)", filter.Field), filter.Value);

filter.Field is name column (Int32)

I get error:

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

How correctly convert?

something like a partial search on a number ? – Raphaël Althaus Feb 07 '13 at 08:39 — Raphaël Althaus, Feb 07 '13 at 08:39

score 0 · Answer 1 · answered Feb 07 '13 at 08:40

0

I'd create a switch statement with all possible values for filter.Field, then use the EF generated properties.

answered Feb 07 '13 at 08:40

Echilon

If you are using EF then I would use `SqlFunctions.StringConvert` – Neil Knight Feb 07 '13 at 08:41
No property or field 'SqlFunctions' exists in type 'CompanyListItem' – Mediator Feb 07 '13 at 09:08
`SqlFunctions` is a `static` class. – Neil Knight Feb 07 '13 at 09:53

1 Answers1