Thanks for your answer.
However, your example is for exact matching string comparison and I need partial matches; that's why I was trying to use
IndexOf() in my question. Also, I dont know why you link the Lstring.ToLower
() doc page since you are calling .ToString() before ToLower() in your example.
I made some more tests with NewsItems and I came to some results using .ToString().ToUpper().IndexOf(myFilterToUpper)
which is not very clean or optimal but at least is working.
Nevertheless there's still a problem.
In my code, the way I filter news is always the same:
news = news.Where(
n => n.Content.ToString().ToUpper().IndexOf(textFilterUpper) > -1);
But I dont have the same number of results depnding on the way I fetch my initial data:
I get more results when I get my initial data with:
IEnumerable<NewsItem> news = App.WorkWith()
var news = App.WorkWith()
Even when I remove the ToUpper() I still get different number of results with the different sources...
Can you explain me what is implemented differently in your fluent API or on database side ?
Maybe it's a bug ?
I wasted enough time on this issue.