In the below code, how do I set CaseSensitiveCollation=true

private static bool isduplicaterecord(string inputstring) // check duplicate records in table {

        var adapteraccountnature = new DataAccessAdapter();
        var accountnature = new AccountnatureEntity();

        accountnature.Description = ClubCentricBISpecific.ChangeCase.ToTitleCase(inputstring);
        accountnature.Flag = ClubCentricBISpecific.StandardFlag.recordvalidflag;
        adapteraccountnature.FetchEntityUsingUniqueConstraint(accountnature,
                                                                accountnature.ConstructFilterForUCDescriptionFlag());
        return (accountnature.Fields.State) == EntityState.Fetched;
    }

What is the sql predicate you want to achieve? You can set CaseSensitiveCollation this way: .

..
IPredicateExpression filter = new PredicateExpression();

FieldLikePredicate filterUCCase1 = new FieldLikePredicate(AccountnaturFields.Description, null,
     ClubCentricBISpecific.ChangeCase.ToTitleCase(inputstring));
filterUCCase1.CaseSensitiveCollation = true;

FieldLikePredicate filterUCCase2 = new FieldLikePredicate(AccountnaturFields.Flag, null,
     ClubCentricBISpecific.StandardFlag.recordvalidflag));
filterUCCase2.CaseSensitiveCollation = true;

filter.Add(filterUCCase1);
filter.Add(filterUCCase2);

adapteraccountnature.FetchEntityUsingUniqueConstraint(accountnature,
     filter);
...

CaseSensitiveCollation = true, it will emit UPPER(...) for the involved fields so you must send UPPER strings for the values.

daelmo wrote:

What is the sql predicate you want to achieve? You can set CaseSensitiveCollation this way: .

..
IPredicateExpression filter = new PredicateExpression();

FieldLikePredicate filterUCCase1 = new FieldLikePredicate(AccountnaturFields.Description, null,
     ClubCentricBISpecific.ChangeCase.ToTitleCase(inputstring));
filterUCCase1.CaseSensitiveCollation = true;

FieldLikePredicate filterUCCase2 = new FieldLikePredicate(AccountnaturFields.Flag, null,
     ClubCentricBISpecific.StandardFlag.recordvalidflag));
filterUCCase2.CaseSensitiveCollation = true;

filter.Add(filterUCCase1);
filter.Add(filterUCCase2);

adapteraccountnature.FetchEntityUsingUniqueConstraint(accountnature,
     filter);
...

CaseSensitiveCollation = true, it will emit UPPER(...) for the involved fields so you must send UPPER strings for the values.

Thanks. It worked the way i wanted

Hi I tried the above code for Oracle 11g. It is not working. I am using Selfservicing method. whether the above implementation is different for self serviving?

Here is my code:

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

Set CaseSensitveCollation to true rather than false.

Matt