Hi, i try do this:
Code: Select all
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?