title: Entity Framework 5, Code First, Full Text Search but IQueryable via CreateQuery?
body: <p>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:</p>
  
  <ul>
  <li><p>Stored procedures nor Table Value Functions can not be mapped with Code First.</p></li>
  <li><p>Still I can call them using dynamic sql</p>
  
  <p><em>dbContext.Database.SqlQuery&lt;Movie&gt;(Sql, parameters)</em></p></li>
  </ul>
  
  <p>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.</p>
  
  <ul>
  <li><p>What I have found that could fulfill my needs is CreateQuery function from IObjectContextAdapter that looks like this(Select All just for test):</p>
  
  <p><em>IQueryable&lt;Movie&gt; result = ((IObjectContextAdapter)dbContext).ObjectContext.CreateQuery&lt;Movie&gt;("SELECT &#42; FROM Movie");</em></p></li>
  <li><p>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.'</p></li>
  </ul>
  
  <p>So the questions are:</p>
  
  <ul>
  <li><p>Why do I get this exception and can it be fixed ?</p></li>
  <li><p>If not is there any way with Code First to do FTS that returns IQueryable ?</p></li>
  </ul>