Entity Framework 5, Code First, Full Text Search but IQueryable via CreateQuery?

Question

I am using .NET 4.5 and EF 5 with Code First approach and now I need to implement Full Text Search. I have already read a lot about it and so far my conclusions are:

Stored procedures nor Table Value Functions can not be mapped with Code First.
Still I can call them using dynamic sql

dbContext.Database.SqlQuery<Movie>(Sql, parameters)

But this returns IEnumerable and I want IQueryable so that I can do more filtering before fetching the data from db server. I know I can send those parameters to Db function but I don't want that.

What I have found that could fulfill my needs is CreateQuery function from IObjectContextAdapter that looks like this(Select All just for test):

IQueryable<Movie> result = ((IObjectContextAdapter)dbContext).ObjectContext.CreateQuery<Movie>("SELECT * FROM Movie");
However executing this throws Exception" 'System.Data.EntitySqlException was unhandled HResult=-2146232006 Message=The query syntax is not valid. Near term '*', line 1, column 9.'

So the questions are:

Why do I get this exception and can it be fixed ?
If not is there any way with Code First to do FTS that returns IQueryable ?

Just to update answer: My post(at the moment it is the last one) on the following topic: a-composable-full-text-search-with-a-code-first-model — borisdj
– borisdj, Commented Dec 23, 2013 at 13:45

Community · Accepted Answer · 2017-05-23 11:57:18Z

2

Try it like this

ObjectQuery<Movie> query = 
    objectContext.CreateQuery<Movie>(@"SELECT VALUE movie FROM Movies");

As for why see these links

Differences from Transact-SQL Unlike Transact-SQL, Entity SQL does not support use of the * argument in the SELECT clause. Instead

Entity SQL Reference - SELECT
"SELECT VALUE" - value keyword in LINQ/Entity Framework query

edited May 23, 2017 at 11:57

CommunityBot

11 silver badge

answered Apr 21, 2013 at 20:35

NSGaga

14.4k3 gold badges43 silver badges51 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Entity Framework 5, Code First, Full Text Search but IQueryable via CreateQuery?

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related