Entity Framework and Case Insensitive String Search

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?

possible duplicate of linq to entities case sensitive comparison — xanatos
– xanatos, Commented Sep 14, 2011 at 11:21
You can use the ToUpper() as I have written here stackoverflow.com/questions/5080727/… — xanatos
– xanatos, Commented Sep 14, 2011 at 11:21

Piotr Auguscik · Accepted Answer · 2011-09-14 11:19:49Z

13

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.

answered Sep 14, 2011 at 11:19

Piotr Auguscik

3,6911 gold badge25 silver badges31 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

a.boussema Over a year ago

And what about Oracle. If the dataAccess is built on top of EF because of Multi-RDBMS support. I can't resolve the problem on Oracle.

Zapnologica Over a year ago

So there is no way to specify whether we want a case sensitive or case insensitive search using EF?

Collectives™ on Stack Overflow

Entity Framework and Case Insensitive String Search

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related