LLBLGEN 4.0 LLBLGEN Run Time framework

Dear Team,

Just need one small help as to how to use CaseSensitiveCollation in my following code.

var title = new TitleCollection(); Filter.Clear();

            Filter.Add(new FieldCompareValuePredicate(TitleFields.Description, ComparisonOperator.Equal,
                                                      description))
                  .AddWithAnd(new FieldCompareValuePredicate(TitleFields.Flag, ComparisonOperator.Equal,
                                                             StaticVariableClass.Flagvalid));
            title.GetMulti(Filter, 0, null, null, null, null, 0, 0);
            return title.Count > 0;

You should create a FieldLikePredicate with CaseSensitiveCollection=true. Example:

var likePredicate = new FieldLikePredicate(EmpFields.EmpName, theName.ToUpper());
likePredicate.CaseSensitiveCollation = true;

Otherwise you might just need to apply a DBFunctionCall (UPPER for example) on the required field, and provide the ToUpper() version of the string, to the predicate.

Walaa wrote:

You should create a FieldLikePredicate with CaseSensitiveCollection=true. Example:

var likePredicate = new FieldLikePredicate(EmpFields.EmpName, theName.ToUpper());
likePredicate.CaseSensitiveCollation = true;

Otherwise you might just need to apply a DBFunctionCall (UPPER for example) on the required field, and provide the ToUpper() version of the string, to the predicate.

Hope this is how it is !

var title = new TitleCollection(); Filter.Clear(); var likePredicate = new FieldLikePredicate(TitleFields.Description, description.ToUpper()); likePredicate.CaseSensitiveCollation = true; Filter.Add(new FieldCompareValuePredicate(TitleFields.Flag, ComparisonOperator.Equal, StaticVariableClass.Flagvalid)); Filter.Add(likePredicate); title.GetMulti(Filter, 0, null, null, null, null, 0, 0); return title.Count > 0;

Yes, that should work indeed. Give it a try