LINQ – Making LINQ Case Sensitive in SQL Server

linqlinq-to-sqlsqlsql-serversql-server-2008

I am using vs 2010 with linq to sql and sql server 2008. how would i made this case sensitive

  var Groups = from gp in _db.Groups 
               where gp.vcr_GroupName == GroupName 
               select gp;

here groupname=abc and groupname=ABC is same

Best Answer

That's not a point for a linq query.

It's a setting within the sql server 2008. Microsoft Sql Server 2008 handles string comparisons by default case invariant.

Have a look at: http://msdn.microsoft.com/en-us/library/ms141038.aspx

Related Solutions

.NET – Case Insensitive String Compare in LINQ-to-SQL

As you say, there are some important differences between ToUpper and ToLower, and only one is dependably accurate when you're trying to do case insensitive equality checks.

Ideally, the best way to do a case-insensitive equality check would be:

String.Equals(row.Name, "test", StringComparison.OrdinalIgnoreCase)

NOTE, HOWEVER that this does not work in this case! Therefore we are stuck with ToUpper or ToLower.

Note the OrdinalIgnoreCase to make it security-safe. But exactly the type of case (in)sensitive check you use depends on what your purposes is. But in general use Equals for equality checks and Compare when you're sorting, and then pick the right StringComparison for the job.

Michael Kaplan (a recognized authority on culture and character handling such as this) has relevant posts on ToUpper vs. ToLower:

He says "String.ToUpper – Use ToUpper rather than ToLower, and specify InvariantCulture in order to pick up OS casing rules"

LINQ – Case Sensitivity in LINQ Queries

LINQ has no concept of case sensitivity, it only cares about boolean evaluation. So if you want to ignore case, you should do something like:

query = query.Where(x => (x.Name.ToLower().Contains(Name.ToLower())));

Chances are you will want to pass a CultureInfo to ToLower() (or use ToLowerInvariant()), and you might want to cache the result of Name.ToLower() so as to not have to perform that operation a potentially large number of times, but this should get you started.

Best Answer

Related Solutions

.NET – Case Insensitive String Compare in LINQ-to-SQL

LINQ – Case Sensitivity in LINQ Queries

Related Question