Ayende @ Rahienhttp://ayende.comAyende @ RahienCopyright (C) Ayende Rahien 2004 - 2021 (c) 202660Ayende Rahien commented on NH Prof New Feature: Alert on bad ‘like’ queryDavid, You write a linq extension http://ayende.com/4717/nh-prof-new-feature-alert-on-bad-like-query#comment8http://ayende.com/4717/nh-prof-new-feature-alert-on-bad-like-query#comment8Sat, 11 Dec 2010 05:15:39 GMTDavid Neale commented on NH Prof New Feature: Alert on bad ‘like’ queryIs there any way to use full text indexes without having to resort to HQL? I use LINQ to implement a specification pattern and can't think of a way to introduce HQL to this. http://ayende.com/4717/nh-prof-new-feature-alert-on-bad-like-query#comment7http://ayende.com/4717/nh-prof-new-feature-alert-on-bad-like-query#comment7Fri, 10 Dec 2010 10:03:02 GMTSteve commented on NH Prof New Feature: Alert on bad ‘like’ queryDavid, Honestly, I've met a lot of developers who really don't understand how SQL works under the hood, so they might not be aware that this type of query does a full table scan. Especially when the code they write is .Contains("EF"). http://ayende.com/4717/nh-prof-new-feature-alert-on-bad-like-query#comment6http://ayende.com/4717/nh-prof-new-feature-alert-on-bad-like-query#comment6Thu, 09 Dec 2010 19:50:49 GMTAyende Rahien commented on NH Prof New Feature: Alert on bad ‘like’ queryVariant, You use the database full text indexes, or Lucene. http://ayende.com/4717/nh-prof-new-feature-alert-on-bad-like-query#comment5http://ayende.com/4717/nh-prof-new-feature-alert-on-bad-like-query#comment5Thu, 09 Dec 2010 12:40:23 GMTDuncan Godwin commented on NH Prof New Feature: Alert on bad ‘like’ queryThat should be date parts. http://ayende.com/4717/nh-prof-new-feature-alert-on-bad-like-query#comment4http://ayende.com/4717/nh-prof-new-feature-alert-on-bad-like-query#comment4Thu, 09 Dec 2010 12:17:34 GMTDuncan Godwin commented on NH Prof New Feature: Alert on bad ‘like’ queryNice feature! I supposed the equivalent for dates would be really easy to implement as well :) http://ayende.com/4717/nh-prof-new-feature-alert-on-bad-like-query#comment3http://ayende.com/4717/nh-prof-new-feature-alert-on-bad-like-query#comment3Thu, 09 Dec 2010 12:16:33 GMTDavid Neale commented on NH Prof New Feature: Alert on bad ‘like’ queryWhy did you choose to make this alert an error as opposed to an alert? Are there not times when an open query like this is necessary? http://ayende.com/4717/nh-prof-new-feature-alert-on-bad-like-query#comment2http://ayende.com/4717/nh-prof-new-feature-alert-on-bad-like-query#comment2Thu, 09 Dec 2010 12:05:06 GMTVariant commented on NH Prof New Feature: Alert on bad ‘like’ queryThat makes sense. Is there a "right" way to allow in-string search? http://ayende.com/4717/nh-prof-new-feature-alert-on-bad-like-query#comment1http://ayende.com/4717/nh-prof-new-feature-alert-on-bad-like-query#comment1Thu, 09 Dec 2010 10:53:57 GMT