Hi,

I am using oracle 11g as my database for my WPF application. I need to implement a case insensitive search without doing any modification in Oracle server settings. I have seen the following forum about this kind of implementation.

http://www.llblgen.com/tinyforum/Messages.aspx?ThreadID=829 But this is almost six years old. Is any other better way introduced/available in the newer versions? I am using LLBLGEN 3.0 now. If it is not could anybody tell that where exactly I need to place the class given in the above forum?

See the documentation at http://www.llblgen.com/documentation/2.6/Using%20the%20generated%20code/Adapter/Filtering%20and%20Sorting/gencode_filteringpredicateclasses_adapter.htm#FieldLikePredicate - there is a parameter to control case sensitve searching.

Matt

Thanks Matt,

It is now working with the following code:

 string searchTerm = languageTerm.ToUpper();
 IPredicateExpression filter = new PredicateExpression();
 FieldLikePredicate caseInSenstivefilter = new   FieldLikePredicate(LanguagetermFields.Languageterm, searchTerm);
 caseInSenstivefilter.CaseSensitiveCollation = true;
 filter.Add(caseInSenstivefilter);