DevForce Community Forum : 2010->2012 query generation issue http://www.ideablade.com/forum/ This is an XML content feed of; DevForce Community Forum : DevForce 2012 : 2010->2012 query generation issue Fri, 10 Apr 2026 18:55:15 -700 Mon, 18 Mar 2013 16:00:33 -700 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 9.69 360 www.ideablade.com/forum/RSS_post_feed.asp?TID=4032 DevForce Community Forum http://www.ideablade.com/forum/forum_images/IdeaBlade_logo_tm.png http://www.ideablade.com/forum/ 2010->2012 query generation issue : katit, FilterOperator.Contains... http://www.ideablade.com/forum/forum_posts.asp?TID=4032&PID=16051#16051 Author: kimj
Subject: 4032
Posted: 18-Mar-2013 at 4:00pm

katit, FilterOperator.Contains will be translated into a SQL LIKE clause if the "IgnoreCase" option on the PredicateDescription is turned off.  By default it's on, so a ToLower method is added to both the property and value clauses, which in turn causes EF to  translate the expression using the SQL CharIndex method. 
 
To avoid unexpected results when the filter is empty you can disable the option.  When the filter is not empty you may want the option enabled, depending on your database. 
 
var pd = PredicateBuilder.Make(typeof(T), filterBoxRow.FieldName, FilterOperator.Contains, filterBoxRow.GetFilterFrom()));
pd.IgnoreCase = false;
predicates.Add(pd);
]]> Mon, 18 Mar 2013 16:00:33 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=4032&PID=16051#16051 2010->2012 query generation issue : Hi katit, I was able to verify... http://www.ideablade.com/forum/forum_posts.asp?TID=4032&PID=16014#16014 Author: sbelini
Subject: 4032
Posted: 14-Mar-2013 at 10:13am

Hi katit,

I was able to verify the behavior.
I'm filing a bug report and will let you know once we have it fixed.

sbelini.]]> Thu, 14 Mar 2013 10:13:04 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=4032&PID=16014#16014 2010->2012 query generation issue : I had code like this: case Fi... http://www.ideablade.com/forum/forum_posts.asp?TID=4032&PID=15985#15985 Author: katit
Subject: 4032
Posted: 12-Mar-2013 at 8:38pm

I had code like this:

case FilterChoice.Contains:
                        predicates.Add(PredicateBuilder.Make(typeof(T), filterBoxRow.FieldName, FilterOperator.Contains, filterBoxRow.GetFilterFrom()));
                        break;

Basically, I'm building filter manually. If there is empty string it generates WHERE statement like this:

WHERE ( CAST(CHARINDEX(LOWER(N''), LOWER([Extent1].[UserName])) AS int)) > 0

And it effectively filter's out whole thing.. I think it should do "LIKE '%%'" ?]]> Tue, 12 Mar 2013 20:38:19 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=4032&PID=15985#15985