Entity Framework and Case Insensitive String Search

Question

Entity Framework and Case Insensitive String Search

entity-framework linq

Question

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?

sternr

View more on Stack Overflow

Piotr Auguscik · Accepted Answer · 9/14/2011 11:19:49 AM

Accepted Answer

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.

Piotr Auguscik

Entity Framework and Case Insensitive String Search

Question

Fastest Entity Framework Extensions

Accepted Answer

Performance

Expression Evaluator

Related