How can I get .ToUpper() (or the equivalent) to work when using .Contains() in Linq to Sql?
- by quakkels
This code:
keyword = 's';
IEnumerable<Member> searchResults = (from m in members
where m.ScreenName.ToUpper().Contains(keyword.ToUpper())
select m).AsEnumerable();
Only returns records that have an uppercase 'S' in the ScreenName. Why is m.ScreenName.ToUpper() being ignored? How do I convert m.ScreenName to uppercase so I can perform case-insensetive checks?