DevForce Community Forum : Case InSensitive string Query http://www.ideablade.com/forum/ This is an XML content feed of; DevForce Community Forum : DevForce 2010 : Case InSensitive string Query Wed, 10 Jun 2026 17:03:02 -700 Mon, 23 Aug 2010 12:31:18 -700 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 9.69 360 www.ideablade.com/forum/RSS_post_feed.asp?TID=2081 DevForce Community Forum http://www.ideablade.com/forum/forum_images/IdeaBlade_logo_tm.png http://www.ideablade.com/forum/ Case InSensitive string Query : Hey great. I blamed the customer... http://www.ideablade.com/forum/forum_posts.asp?TID=2081&PID=8150#8150 Author: WardBell
Subject: 2081
Posted: 23-Aug-2010 at 12:31pm

Hey great. I blamed the customer for not having the proper environment ... like mine ... like DF preview bits that you couldn't possibly have. Sorry about that!]]> Mon, 23 Aug 2010 12:31:18 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=2081&PID=8150#8150 Case InSensitive string Query : That did it! Thanks! http://www.ideablade.com/forum/forum_posts.asp?TID=2081&PID=8147#8147 Author: EisenbergEffect
Subject: 2081
Posted: 23-Aug-2010 at 12:26pm

That did it! Thanks!]]> Mon, 23 Aug 2010 12:26:27 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=2081&PID=8147#8147 Case InSensitive string Query : We added support for serialization... http://www.ideablade.com/forum/forum_posts.asp?TID=2081&PID=8144#8144 Author: kimj
Subject: 2081
Posted: 23-Aug-2010 at 11:20am

We added support for serialization of the StringComparison type in 6.0.5.  You can work around this now by adding this as a known type; see my reply here - http://www.ideablade.com/forum/forum_posts.asp?TID=2080.
]]> Mon, 23 Aug 2010 11:20:28 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=2081&PID=8144#8144 Case InSensitive string Query : The technique definitely works... http://www.ideablade.com/forum/forum_posts.asp?TID=2081&PID=8141#8141 Author: WardBell
Subject: 2081
Posted: 23-Aug-2010 at 10:24am

The technique definitely works ... on all of our machines. Something is not quite right in your environment. Following up with you outside the forum. I'll be back with the resolution for our genernal audience.]]> Mon, 23 Aug 2010 10:24:03 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=2081&PID=8141#8141 Case InSensitive string Query : Unfortunately, this solution... http://www.ideablade.com/forum/forum_posts.asp?TID=2081&PID=8138#8138 Author: EisenbergEffect
Subject: 2081
Posted: 23-Aug-2010 at 7:00am

Unfortunately, this solution does not work. It causes a serialization error:

There was an error while trying to serialize parameter http://ideablade.com/EntityModel:entityQuerySurrogate. The InnerException message was 'Type 'System.StringComparison' with data contract name 'StringComparison:http://schemas.datacontract.org/2004/07/System' is not expected. Add any types not known statically to the list of known types - for example, by using the KnownTypeAttribute attribute or by adding them to the list of known types passed to DataContractSerializer.'.  Please see InnerException for more details.

Getting this simple scenario working is *critical* for our application. I'm using version 6.0.4


Edited by EisenbergEffect - 23-Aug-2010 at 7:12am]]> Mon, 23 Aug 2010 07:00:01 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=2081&PID=8138#8138 Case InSensitive string Query : That will work in the mean time.... http://www.ideablade.com/forum/forum_posts.asp?TID=2081&PID=8124#8124 Author: EisenbergEffect
Subject: 2081
Posted: 20-Aug-2010 at 4:46pm

That will work in the mean time. Thanks!]]> Fri, 20 Aug 2010 16:46:08 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=2081&PID=8124#8124 Case InSensitive string Query : Our next build will have queries... http://www.ideablade.com/forum/forum_posts.asp?TID=2081&PID=8122#8122 Author: ting
Subject: 2081
Posted: 20-Aug-2010 at 4:14pm

Our next build will have queries set to the SQL Server defaults (case insensitive, ignore trailing whitespace), and will have options for you to configure the behavior if you need something different.

In the meantime, you can perform the query like this:
entityManager.Employees.Where(emp => emp.FirstName.Equals("Kathy", StringComparison.CurrentCultureIgnoreCase);
 
]]> Fri, 20 Aug 2010 16:14:35 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=2081&PID=8122#8122 Case InSensitive string Query : Some additional information about... http://www.ideablade.com/forum/forum_posts.asp?TID=2081&PID=8120#8120 Author: bennage
Subject: 2081
Posted: 20-Aug-2010 at 2:37pm

Some additional information about this problem. The db is case insensitive.
I'm catching the generated SQL with EFPRof and when I run it manually I get a row back. Is DevForce possibly filtering the results from the db?]]> Fri, 20 Aug 2010 14:37:50 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=2081&PID=8120#8120 Case InSensitive string Query : I would like to use linq... http://www.ideablade.com/forum/forum_posts.asp?TID=2081&PID=8119#8119 Author: EisenbergEffect
Subject: 2081
Posted: 20-Aug-2010 at 11:05am

I would like to use linq to query for all Persons with a certain Name. However, I would like to do this in a case insensitive way. Currently, I am using Name.Contains(searchText), but that isn't working.

Edited by EisenbergEffect - 02-Sep-2010 at 11:28am]]> Fri, 20 Aug 2010 11:05:37 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=2081&PID=8119#8119