how can i use SqlFunctions with dotConnect
Posted: Mon 31 Jan 2011 20:25
Hi!
i would like to convert an Int into a string and compare it to a value directly in the database. This post http://stackoverflow.com/questions/1228 ... 50#3293050 suggest to use SqlFunctions in the Where clause and it will be converted in a sql statement that the database will know.
But with dotConnect, it doesnt seems to work. Is it possible to know how i should do it?
heres my Linq query:
i would like to convert an Int into a string and compare it to a value directly in the database. This post http://stackoverflow.com/questions/1228 ... 50#3293050 suggest to use SqlFunctions in the Where clause and it will be converted in a sql statement that the database will know.
But with dotConnect, it doesnt seems to work. Is it possible to know how i should do it?
heres my Linq query:
Code: Select all
from commande in this.ObjectSet
where commande.TypeCommande.Nom.Contains(keyword) ||
SqlFunctions.StringConvert((double)commande.CommandeId).Contains(keyword)
select commande;