I use a PagedCollectionViewAdapter for IPager<T> - Cocktail. So, I don't control the query execution itself. I just pass my IPagerRepository, a predicate and then call GoToPageAsync to load data.

Maybe, I can execute first a query against database and after put my strategy to cache only in IPagerRepository.

 

One option is to break this into two separate queries, one to execute against the database only, and another to execute against cache only.  The cache only query can then call a local function to remove the accent prior to the string compare.  See the RemoveDiacritics method in this StackOverflow post - http://stackoverflow.com/questions/359827/ignoring-accented-letters-in-string-comparison - for more information.  The local query might then look like:

 

  EntityManager.People.Where(person => RemoveDiacritics(person.Name).Contains("ao"))

 

Not ideal, but maybe other DevForce developers have encountered this problem and have some suggestions.

I'm trying to created a accent insensitive search in my app. 

For instance, I have this rows:

Name

-------

Ricardo Ribeiro

João Souza

Paolo Guerreiro

If I do this:

  var query = UnitOfWork.EntityManager.People          .Where(person => person.Name.Contains("ao")); 

  var result = query.Execute();

I expect this result:

But, my collection result is just "Paolo Guerreiro", because just this ocurrence contains "ao" without accent.