Case insensitive string compare in LINQ-to-SQL

by

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“

More Related Contents:

  1. LINQ to Entities does not recognize the method
  2. What is the difference between IQueryable and IEnumerable?
  3. How to do SQL Like % in Linq?
  4. How to loop through all the properties of a class?
  5. Does XSLT have a Split() function?
  6. Is the Microsoft.VisualBasic namespace “true .NET” code?
  7. “Or” equivalent in Linq Where() lambda expression
  8. Pick unique Random numbers
  9. LINQ Single vs First
  10. How to flatten nested objects with linq expression
  11. Which is generally best to use — StringComparison.OrdinalIgnoreCase or StringComparison.InvariantCultureIgnoreCase?
  12. EF LINQ include multiple and nested entities
  13. Difference between Lookup() and Dictionary(Of list())
  14. .NET LINQ query syntax vs method chain
  15. How do I validate email address formatting with the .NET Framework?
  16. Option Strict On and .NET for VB6 programmers
  17. RestSharp serialization to JSON, object is not using SerializeAs attribute as expected
  18. Does LINQ work with IEnumerable?
  19. How to print datagridview table with its header in vb.net?
  20. How to use “contains” or “like” in a dynamic linq query?
  21. Entity Framework 4 Single() vs First() vs FirstOrDefault()
  22. How to convert date format in vb.net?
  23. What can I do to resolve a “Row not found or changed” Exception in LINQ to SQL on a SQL Server Compact Edition Database?
  24. Redirect Trace output to Console
  25. How to make a Windows Forms .NET application display as tray icon?
  26. Assigning a value to ComboBox Items
  27. Linq: What is the difference between Select and Where
  28. Should I always use the AndAlso and OrElse operators?
  29. Is there a way to define an implicit conversion operator in VB.NET?
  30. How to Convert Row to Column in Linq and SQL

Leave a Comment