Devart Forums

Posted: **Thu 13 Jan 2011 00:32**

Hi, i try do this:

 
string esql = "SELECT VALUE test  FROM Entities.test AS test WHERE CAST(test.NumeroRA as Edm.String) like @param";

ObjectQuery QueryTest = new ObjectQuery(esql, Context);
QueryTest .Parameters.Add(new ObjectParameter("param", "%'" +id.ToString() + "'%"))

but i get error:"Edm.String type no found", i want perform a like with a numeric value, so i want cast/convert field to use like operator...with sql server provider this query run fine, but when i try with devart provider i get this error, how i can peform a like with devart using linq or esql?

Posted: **Fri 14 Jan 2011 13:31**

Thank you for the report, I have reproduced the issue.
However, the same problem is reproducible using SQL Server on my system.
I will let you know about the results of our investigation.

Posted: **Tue 18 Jan 2011 14:23**

The solution for the problem is to use System.String instead of Edm.String.

Devart Forums

how Cast/Convert numeric to string to perform like?linq/esql

how Cast/Convert numeric to string to perform like?linq/esql