CODEWITHSUNDEEP
linqentity-framework
sternr
sternr

Reputation: 6536

Entity Framework and Case Insensitive String Search

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?

Upvotes: 9

Views: 10761

Answers (1)

Piotr Auguscik
Piotr Auguscik

Reputation: 3681

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.

Upvotes: 13

Related Questions