In Microsoft Entity Model Framework, how to run a SQL Raw Query

c# entity-framework linq-to-entities search

Question

To access my database, I'm using Microsoft Entity model framework. When I use this execute query command to conduct a SQL raw query, I encounter a problem. Tell me how I could address the problem.

svdc.CreateQuery<VideoMasterTable>(
    "select * from videomastertable WHERE FREETEXT(*, '"+keyword+"')"
    ).ToList();

I appreciate you,

Kanal

1
2
4/30/2010 12:54:27 PM

Popular Answer

CreateQuery not T-SQL, but ESQL You can only use EF 4 for this.ExecuteStoreQuery instead.

4
4/30/2010 1:02:56 PM


Related Questions





Related

Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow
Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow