I'm using Microsoft Entity model framework to access my database. I get an issue while i use this execute query command for executing Sql raw query. Let me know how could i resolve it.
svdc.CreateQuery<VideoMasterTable>(
"select * from videomastertable WHERE FREETEXT(*, '"+keyword+"')"
).ToList();
Thanks in Advance,
Kanal
CreateQuery
takes ESQL, not T-SQL. In EF 4 (only), you can use ExecuteStoreQuery
instead.