I have a Entity Framework entity with a string Property named Description.
Searching for all entities where the Description contains a string is as simple as:
var res = from u ctx.Users where u.Description.contains(str) select u;
But suppose I want to support case insensitive search?
If you're using
Linq to enties the search is done by the sql server so if the search is case sensitive or not depends on server settings.