A string property called Description is a part of an Entity Framework entity I have.
It is easy to search for all entities when the Description includes a certain text by typing:
var res = from u ctx.Users where u.Description.contains(str) select u;
Imagine, however, that I wish to implement case-insensitive search.
If you use
Linq to enties
The sql server does the search; hence, whether or not the search is case sensitive relies on server settings.