title: Entity Framework, Code First and Full Text Search
body: <p>I realize that a lot of questions have been asked relating to full text search and Entity Framework, but I hope this question is a bit different.</p>
  
  <p>I am using Entity Framework, Code First and need to do a full text search.  When I need to perform the full text search, I will typically have other criteria/restrictions as well - like skip the first 500 rows, or filter on another column, etc.</p>
  
  <p>I see that this has been handled using table valued functions - see <a href="http://sqlblogcasts.com/blogs/simons/archive/2008/12/18/LINQ-to-SQL---Enabling-Fulltext-searching.aspx">http://sqlblogcasts.com/blogs/simons/archive/2008/12/18/LINQ-to-SQL---Enabling-Fulltext-searching.aspx</a>.  And this seems like the right idea.</p>
  
  <p>Unfortunately, table valued functions are not supported until Entity Framework 5.0 (and even then, I believe, they are not supported for Code First).  </p>
  
  <p>My real question is what are the suggestions for the best way to handle this, both for Entity Framework 4.3 and Entity Framework 5.0.  But to be specific:</p>
  
  <ol>
  <li><p>Other than dynamic SQL (via <code>System.Data.Entity.DbSet.SqlQuery</code>, for example), are there any options available for Entity Framework 4.3?</p></li>
  <li><p>If I upgrade to Entity Framework 5.0, is there a way I can use table valued functions with code first?</p></li>
  </ol>
  
  <p>Thanks,
  Eric</p>