使用正则表达式MongoDB C#驱动程序进行过滤 [英] Filter with regex MongoDB C# driver

问题描述

我正在尝试将originalEmail的字段与[e-mail]之类的邮件地址进行匹配，但是无论如何，区分大小写的方法也可以找到[e-mail]的字段.

I am trying to match the fields of originalEmail with a mail address like [e-mail], but no matter, case sensitive means to also find [e-mail] fields.

public ObjectId? GetEntityIdByOriginalEmail(string originalEmail)
{
    FilterDefinition<Entity> filter = "{ x : { $regex : /" + originalEmail + "//i } }";
    var entity = _entitiesStorage.GetSingleOrDefault(filter);

    if (entity == null)
        return null;

    return entity._id;
}

这对我不起作用.为什么?

This didn't work for me. Why?

推荐答案

您可以使用Builders.Filter.Regex.

public async Task<Entity> GetEntityIdByOriginalEmail(string originalEmail)
{
    var collection = GetCollection();
    var filter = Builders<Entity>.Filter.Regex("x", new BsonRegularExpression(originalEmail, "i"));
    return await collection.Find(filter).FirstOrDefaultAsync();
}

这篇关于使用正则表达式MongoDB C#驱动程序进行过滤的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！