MongoDB and C#: Case insensitive search

by

The simplest and safest way to do that is using Linq:

var names = namesCollection.AsQueryable().Where(name =>
    name.FirstName.ToLower().Contains("hamster"));

As explained in the tutorial ToLower, ToLowerInvariant, ToUpper and ToUpperInvariant all perform matches in a case insensitive way. After that you can use all the supported string methods like Contains or StartsWith.

This example will generate:

{
    "FirstName" : /hamster/is
}

The i option makes it case insensitive.

More Related Contents:

  1. MongoDB GridFs with C#, how to store files such as images?
  2. BsonSerializationException when serializing a Dictionary to BSON
  3. Mongodb query equivalent of the following SQL query
  4. Is there a C# case insensitive equals operator?
  5. Aggregate $lookup with C#
  6. MongoDB .Net driver 2.0 Pull (remove element)
  7. Is there an “Explain Query” for MongoDB Linq?
  8. MongoDB C# Driver 2.0 – Update document
  9. Get _id of an inserted document in MongoDB?
  10. Could not load file or assembly or one of its dependencies
  11. In C#, what is the difference between public, private, protected, and having no access modifier?
  12. How to use HttpWebRequest (.NET) asynchronously?
  13. Best Practice for Forcing Garbage Collection in C#
  14. The cast to value type ‘Int32’ failed because the materialized value is null
  15. What is the best way to store user settings for a .NET application?
  16. How can I treat the circle as a control after drawing it? – Moving and selecting shapes
  17. How to run a Task on a custom TaskScheduler using await?
  18. How to read attribute value from XmlNode in C#?
  19. How do closures work behind the scenes? (C#)
  20. Calculating Bandwidth
  21. Should I take ILogger, ILogger, ILoggerFactory or ILoggerProvider for a library?
  22. Encrypting/Decrypting large files (.NET)
  23. How to throttle requests in a Web Api?
  24. how to create an audit trail with Entity framework 5 and MVC 4
  25. Drawing a Long String on to a Bitmap results in Drawing Issues
  26. File permissions on Linux/Unix with .NET Core
  27. LINQ: Add RowNumber Column
  28. How to get DPI in C# .NET?
  29. Dynamically loading resource dictionary files to a wpf application gives an error
  30. Create a completed Task

Leave a Comment