从mongodb data C#中查找消除空格的弹性查询

using MongoDB.Driver;
using MongoDB.Bson;
using System;

class Program
{
    static void Main(string[] args)
    {
        // 连接到MongoDB数据库
        var client = new MongoClient("mongodb://localhost:27017");
        var database = client.GetDatabase("your_database_name");
        var collection = database.GetCollection<BsonDocument>("your_collection_name");

        // 构建查询条件
        var filter = Builders<BsonDocument>.Filter.Regex("your_field_name", new BsonRegularExpression("^.*your_search_term.*$", "i"));

        // 执行查询并消除空格
        var results = collection.Find(filter).ToList();
        foreach (var result in results)
        {
            var fieldValue = result["your_field_name"].AsString.Trim();
            Console.WriteLine(fieldValue);
        }
    }
}