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.