DevForce Community Forum : Full Text search http://www.ideablade.com/forum/ This is an XML content feed of; DevForce Community Forum : DevForce Classic : Full Text search Wed, 15 Apr 2026 18:39:30 -700 Fri, 02 May 2008 08:15:45 -700 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 9.69 360 www.ideablade.com/forum/RSS_post_feed.asp?TID=796 DevForce Community Forum http://www.ideablade.com/forum/forum_images/IdeaBlade_logo_tm.png http://www.ideablade.com/forum/ Full Text search : Thanks for the information. I... http://www.ideablade.com/forum/forum_posts.asp?TID=796&PID=2925#2925 Author: danielg
Subject: 796
Posted: 02-May-2008 at 8:15am

Thanks for the information.  I ended up just writing a stored proc and going through that.  I am looking forward to DevForce EF for all the new features.]]> Fri, 02 May 2008 08:15:45 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=796&PID=2925#2925 Full Text search : Unfortunately, with OQL, you are... http://www.ideablade.com/forum/forum_posts.asp?TID=796&PID=2922#2922 Author: davidklitzke
Subject: 796
Posted: 01-May-2008 at 3:10pm

Unfortunately, with OQL, you are stuck with this behavior.  I thought, at first, you might be able to build a custom ADO Provider Helper that would prevent the translation of "Contains" to "Like", but apparently this is not possible.
 
You have a couple of other choices: PassThroughSQL and DevForce EF.
]]> Thu, 01 May 2008 15:10:31 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=796&PID=2922#2922 Full Text search : Is there a way to perform a Full... http://www.ideablade.com/forum/forum_posts.asp?TID=796&PID=2920#2920 Author: danielg
Subject: 796
Posted: 01-May-2008 at 12:40pm

Is there a way to perform a Full Text search using the OQL?  Normally in SQL one would use a "Contains" statement to perform this kind of search.  It is much faster than "Like" especially in multi-column situations.  I tried to create a new query using the EnityQueryOp.Contains operator, but when I view the SQL that is actually created, it translates it to the much slower "Like" statement.  Is there another way?

Thanks, Daniel
]]> Thu, 01 May 2008 12:40:30 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=796&PID=2920#2920